Forum Discussion
Solved
Multiple values under one matrix row header
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 value...
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.
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.
This was exactly right. Thank you so much!
