Multiple values under one matrix row header

[SimpleChemist]

Good morning,

To start, here is a snip of the data set I am working with:

I am trying to create a matrix in power BI, where when a date is selected it will show all of the column header values that include PMI, SMI, RI|, similar to this:

But I am not sure how to make it dynamic in power bi.  Any suggestions would be helpful.  I have tried unpivoting and using the headers as variables but because I need to return multiple per single row I could not find success.

[v-jianboli-msft · Accepted solution]

Hi @SimpleChemist ,

Please try:

First, unpivot the other columns:

Then use the Attribute data to create three table visuals, rename and add filter to the visual:

Then use date data to create a slicer:

Final output:

Best Regards,

Jianbo Li

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

[SimpleChemist]

This was exactly right.  Thank you so much!