Forum Discussion
Ragged hierarchy Visualization
We have a ragged hierarchy in our organization structure. Where some departmensts of the organizations go down to 4 levels, some go down till 8. We are trying to create a Power BI report where differ...
Hi Eric,
In your example there is only one child beneath each level. If a level has multiple children the relationship becomes many-to-many and this solution does not seem to work - am I missing something?
Hi kevinascott ,
Since proposing this solution, Power BI has released tools to manage regged hierarchies better.
I would recommend looking into the expand/collapse formatting option for your matrix viz. You can find this option in the format section by searching '+' in the search bar.
There is also an option to hide blank rows.
I hope this helps.
Best,
Eric