Forum Discussion
Format a bulleted list using Pivot tables and measures
Hello, I created an Xcel pivot table and then created a measure to show text rather than numbers.
That is working fine with the following measure =CONCATENATEX(Goals,[Item]," ● ")
The result of this formula is text that appears in a cell like this
Item 1 ●Item 2 ● Item 3 ●Item 4 (and so on- the text wraps around)
I'd like to have the text appear in the cell as
●Item 1
●Item 2
●Item 3
●Item 4
with a hard break between each bulleted item.
I have not found a way to insert a return code in the expression above -- and it does not appear that this is supported in the measures functions part of Excel -- but just wondering if there is a way to have the Pivot table generate text through the measure function in a list format and not in wrap-around text.
Any help appreciated ..
1 Reply
Update your measure to use UNICHAR(10) for a line break, which is the DAX equivalent of a carriage return in Excel’s Data Model (though its full support might depend on your Excel version). Since you want a bullet followed by a line break, you can combine the bullet character and UNICHAR(10) as the delimiter in CONCATENATEX. Here’s the revised measure:
=CONCATENATEX(Goals, "● " & [Item], UNICHAR(10))
