Forum Discussion
Power BI Matrix Dynamic Row Headers
Hi All,
We have a requirement where we want to change the Row headers of a matrix visual based on Slicer selection.
For Example- Consider a table below.
Category, Region, Sales
A East 100
B East 200
C West 400
D West 500
We want to give a slicer where the two options are Category,Region.
If the User selects Category then the matrix visual shows
Category Sales
A 100
B 200
C 400
D 500
If The User selects Region then
Region Sales
East 300
West 900
Also is there any possibility then this slicer can be multiselect? For Example show both Category and Region?
Thanks
Sumit
3 Replies
- v-xiaotangCommunity Support
Hi datahue
Thanks for reaching out to us.
You need to unpivot your table, kindly refer to the solutions provided in below links:
I also create a sample attached bellow for your reference,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
- v-xiaotangCommunity Support
Hi datahue
Can we close this thread now if there is no other question? It would be nice if you can accpet my answer as the solution. Thanks 🙂
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.