Show Text by Date

[mansi64011]

Hello,

I am trying to create a matrix view where I can show each item by date. However when I try to put Date in Rows and Item name in values, I am just getting first item name. I want to see all the names in a date hierarchy. Is there a DAX measure that I can create for this filter?

[v-xicai]

Hi @mansi64011 ,

You may create a measure like codes below, then put the new measure into the Value box of Matrix visual, disable the Row subtotals in Format pane if necessary.

Measure1=MAX([Item Name])

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try to use concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax