Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello everyone, I have a question about uneven hierarchies.
Is it possible to display several (2 or 3) unequal hierarchies in one visual?
For example, an organization- with an accounting-hierarchy
With one this is no problem, but if I add a second one, the elements of the second one are not displayed in the first one (if the lowest element of the first one does not go to the last level).
Is there a best practice?
Thank you very much
Frank
Solved! Go to Solution.
Unfortunately, displaying multiple uneven (or jagged) hierarchies in a single visual in Power BI might not be supported, because standard visuals like tables, charts, and matrices expect data to conform to uniform levels of hierarchy. When hierarchies do not align perfectly—such as in cases where one hierarchy is deeper than another—it can lead to display and interpretation issues within the visual.
You can explore the Power BI Visuals Marketplace for custom visuals that are designed to handle uneven hierarchies more gracefully than the default set of visuals. Some visuals are specifically designed for complex data structures and might offer the flexibility you need.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, displaying multiple uneven (or jagged) hierarchies in a single visual in Power BI might not be supported, because standard visuals like tables, charts, and matrices expect data to conform to uniform levels of hierarchy. When hierarchies do not align perfectly—such as in cases where one hierarchy is deeper than another—it can lead to display and interpretation issues within the visual.
You can explore the Power BI Visuals Marketplace for custom visuals that are designed to handle uneven hierarchies more gracefully than the default set of visuals. Some visuals are specifically designed for complex data structures and might offer the flexibility you need.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jayleny,
Thank you for your quick reply.
It's a shame on the one hand, but on the other I can now stop trying to make it work somehow.
Thanks
Frank
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |