This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I am using a Treemap visual in Microsoft Power BI to display hierarchical data. Currently, I have configured:
This creates one level of nested rectangles successfully, where the main category contains subcategory rectangles.
However, my requirement is to display an additional nested layer inside the existing subcategory rectangles without using drill-down functionality. I want the hierarchy to appear simultaneously in a fully expanded view
Expected behavior:
I would like to know:
Any suggestions or best practices would be appreciated.
Solved! Go to Solution.
Hello @AnujSahay,
The native Microsoft Power BI Treemap only supports two hierarchy levels being shown at once:
So a setup like:
Category → Subcategory
works fine, but adding another visible nested layer like:
Category → Subcategory → Product
is not supported in the standard Treemap visual unless you use drill-down.
Docs:
A few possible workarounds are:
For a fully expanded 3-level Treemap, a custom visual is probably the best option right now.
Hi @AnujSahay ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank @Olufemi7 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team
Hi @AnujSahay ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team
The treemap stops at two levels in its layout step, so u keep Category → Subcategory in the treemap and show Product in a small separate custom visual beside it for a full three‑level view. this is the only setup that stays fully expanded without drill‑down and works the same in every report.
Hello @AnujSahay,
The native Microsoft Power BI Treemap only supports two hierarchy levels being shown at once:
So a setup like:
Category → Subcategory
works fine, but adding another visible nested layer like:
Category → Subcategory → Product
is not supported in the standard Treemap visual unless you use drill-down.
Docs:
A few possible workarounds are:
For a fully expanded 3-level Treemap, a custom visual is probably the best option right now.
Hello,
I’m not completely sure, but from what I know the native Power BI Treemap only supports one visible nested level at a time, so you usually can’t show Category → Subcategory → Product all expanded together without drill-down
My advice is to search something in the custom visual, they usually give the possibility to add this type of functionality
Best regards,
Daniele
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 |
|---|---|
| 32 | |
| 25 | |
| 23 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |