Power BI

Needs Votes

Ragged or Parent Child Hierarchy Visuals

Vote (514)

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 (59)

Comments (59)

789beeca 025f-46f1-97e4-dad9dec41493 on 05 Jul 2020 23:04:55

RE: Ragged or Parent Child Hierarchy Visuals

Critical functionality I think ...

eb970181 6d8b-4300-a810-48b5d70df969 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.

5f243631 2ead-4957-b97f-4b7ebbda0da1 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.

3101328d e4e2-4d82-a3ff-9aefdd878e1e 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?

233f7263 6b64-40d2-a044-cd6cb0dd5fe1 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.