Forum Discussion
Anonymous
6 years agoNot applicable
How to display table with below format?
Hello, We need to display data as below format in Power BI report? Thanks.
- 6 years ago
Hi Anonymous
You can use Matrix visual for this requirement.
From your screenshot below it is hard to understand the underlying table with "value" column granularity. I considered the underlying table to be like this:
If thats true than you can use Matrix visual and do these steps:
1) Drag all these three columns to Rows
2) Go to visual properties--> Row Headers--> Turn off Stepped Layout and +/- icons
3) Then from visual ellipses click twice on 4th option which says "Expand all down one level in hierarchy"
Below visual will be come:
Mann.
- Anonymous6 years ago
Mannyes, it works, thank you very much for your quick help 🙂
Greg_Deckler
6 years agoCommunity Champion
Use a Matrix.