How can we improve Power BI?

Ragged or Parent Child Hierarchy Visuals

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

312 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

29 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Robson Luiz commented  ·   ·  Flag as inappropriate

    It's a must have feature.
    Ragged hierarchies are used in most of financial models.

    If you have data sources with hierarchy levels implemented in table columns (level0, level1,etc) members should not be filtered cause the entire row will be removed.

    In analysis services you can hide specific members

  • Anonymous commented  ·   ·  Flag as inappropriate

    We're having problems when trying to visualize a ragged hierarchy. We get blanks whenever the leafes is blank. Should e an option to hide empty leaves.

  • Justin Coran commented  ·   ·  Flag as inappropriate

    Agree with other comments that this is a much needed feature. Parent-Child hierarchies are common in health care analytics and associated data operations. Health Systems and Hospitals could benefit from this feature in PowerBI.

  • David Cresp commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Michael Ring commented  ·   ·  Flag as inappropriate

    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...

  • Anonymous commented  ·   ·  Flag as inappropriate

    Guys, this property is already available in the Tabular engine -- please just let the Power BI client utilize it!

  • Van D commented  ·   ·  Flag as inappropriate

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

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.