Forum Discussion

mansi64011's avatar
mansi64011
Frequent Visitor
6 years ago

Show Text by Date

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?

Show and Tell

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    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.