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 thi...
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))