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

292 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      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.