This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
Hi,
I'm trying to mock up a copy of a pivot table or tableau table, in pbi desktop, so I can share on sharepoint.
I think matrix it the right way to get multi-level hierarchy of data, right?
when I add multiple columns I'm able to hit the drilldown thing at the top of the page and see multiple hierarchy levels.
where is this button for rows, I can only see one hierarchy level at a time...
why on earth is the table not showing the table hierarchy by default? hiding the fields --- are viewers supposed to just guess what data is in the table? hahah what is the point of visualizing information if you don't know what it is?
thanks,
s
Solved! Go to Solution.
Ah - turn off stepped levels, right click the data, expand all.
Strongly recommend making this default, crazy that hiding information labels is the status quo of a multi-index table, comically bad and behind tableau / pivot tables in terms of being intuitive
Ah - turn off stepped levels, right click the data, expand all.
Strongly recommend making this default, crazy that hiding information labels is the status quo of a multi-index table, comically bad and behind tableau / pivot tables in terms of being intuitive
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 21 | |
| 21 | |
| 21 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 56 | |
| 53 | |
| 49 | |
| 26 | |
| 26 |