Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ragged or Parent Child Hierarchy Visuals

Vote (776) Share
's profile image

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)
's profile image Profile Picture

Power BI User on 05 Jul 2020 23:28:18

RE: Ragged or Parent Child Hierarchy Visuals

We definitely need this

's profile image Profile Picture

Josh Flory on 05 Jul 2020 23:22:21

RE: Ragged or Parent Child Hierarchy Visuals

SSAS 2017 Tabular added this, why is this not available in Power BI?

's profile image Profile Picture

David Cresp on 05 Jul 2020 23:18:17

RE: Ragged or Parent Child Hierarchy Visuals

Very much needed. Please bring this one in. You can work around with DAX but it really slows things down.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:26

RE: Ragged or Parent Child Hierarchy Visuals

Team, hiding of child with no data in other other visuals, like column, stacked, table and matrix is also very much needed for ragged hierarchy.

's profile image Profile Picture

Monte Holyfield on 05 Jul 2020 23:14:08

RE: Ragged or Parent Child Hierarchy Visuals

Yes, this would be very helpful!

's profile image Profile Picture

Christy Taddei on 05 Jul 2020 23:11:56

RE: Ragged or Parent Child Hierarchy Visuals

Please add this feature, it is very much needed.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:11:18

RE: Ragged or Parent Child Hierarchy Visuals

Not sure if anyone else has hit the same problem but since the December update it seems parent child hierarchies don't work at all with the table visual. As soon as you go beyond level 3 you get an "unexpected error" (seems to be due to the blanks created at each level for the non leaf data members). Hiding these member by setting the property in visual studio seems to do nothing...

's profile image Profile Picture

Van Dang on 05 Jul 2020 23:09:11

RE: Ragged or Parent Child Hierarchy Visuals

This is a critical feature if Microsoft intends to develop Power BI to become a serious financial reporting tool.

's profile image Profile Picture

Andrew Lucius on 05 Jul 2020 23:07:32

RE: Ragged or Parent Child Hierarchy Visuals

The ability to hide blanks on the child hierarchy is critical for drill-down functionality.

See this video for more detail: https://www.youtube.com/watch?v=4Km6HmydY7A

's profile image Profile Picture

Vadim Gerya on 05 Jul 2020 23:04:55

RE: Ragged or Parent Child Hierarchy Visuals

Critical functionality I think ...