Power BI

Needs Votes

Ragged or Parent Child Hierarchy Visuals

Vote (776)

on 02 Jun 2016 13:20:53

Ragged Hierarchy is not population correctly, in case of child with no data there is no option to hide those members

Comments (78)

Comments (78)

Chuck V on 05 Jul 2020 22:58:55

RE: Ragged or Parent Child Hierarchy Visuals

For Profit and Loss as a Ragged Hierarchy the current Matrix seems to work. For Balance Sheet (which has a little more ragged hierarchal) not so much.

Alex on 05 Jul 2020 22:57:10

RE: Ragged or Parent Child Hierarchy Visuals

Excel and Tableau work perfectly with parent-child hierarchies; this is a crucial functionality for those using SSAS data sources with hierarchies.

Kevin H on 05 Jul 2020 22:55:45

RE: Ragged or Parent Child Hierarchy Visuals

Yes! Many of our dimensions are parent/child hierarchies.

I'd like for Power BI to support creating true parent/child hierarchies, in a table. (In addition to the current hierarchy functionality, where you create a hierarchy by picking the set of columns, in order, that constitute the hierarchy.)

Then, all of the visualizations that can use hierarchies, like Matrix, Bar Charts, etc. should just "do the right thing" with parent/child hierarchies.

I think this is the most important feature request out there, right now! It would be such a bigger deal than any of the feature requests that currently have 1,000+ votes.

There have been several copies of this "idea" created, with keywords like "parent/child hierarchy," "self-referencing hierarchy" and "ragged hierarchy." Maybe they could be merged?

Power BI User on 05 Jul 2020 22:53:58

RE: Ragged or Parent Child Hierarchy Visuals

This is a really important to the end customers. It just needs to look right without a lot of work arounds on the data model side. Please help us with this.