Forum Discussion
Solved
Multi-Level Nested Hierarchy in Power BI Treemap Without Using Drill-Down
I am using a Treemap visual in Microsoft Power BI to display hierarchical data. Currently, I have configured: Group → Main Category Details → Subcategory Values → Sales/Measure This creates one...
Hello AnujSahay,
The native Microsoft Power BI Treemap only supports two hierarchy levels being shown at once:
- Group
- Details
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:
- using a custom hierarchical Treemap visual from AppSource
- trying visuals like Decomposition Tree or Sunburst
- combining hierarchy fields into one label column (not true nesting, but sometimes helps)
For a fully expanded 3-level Treemap, a custom visual is probably the best option right now.
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.