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