Forum Discussion
Multi-Level Nested Hierarchy in Power BI Treemap Without Using Drill-Down
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.
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.