Forum Discussion

DataExplorer's avatar
DataExplorer
Frequent Visitor
9 years ago

Ragged hierarchy Visualization

We have a ragged hierarchy in our organization structure. Where some departmensts of the organizations go down to 4 levels, some go down till 8. We are trying to create a Power BI report where differ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi DataExplorer,

Ragged Hierarchy is currently not supported in Power BI Desktop, there is no option to hide blank values in visuals when child Hierarchy has no data in your table. You can vote up this existing idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14511612-ragged-or-parent-child-hierarchy-visuals .

In addition, for hierarchy slicer custom visual, the feature that hide blanks is in development and the feature will be released in the next version(0.8.x), for more details, please review this blog: https://azurebi.jppp.org/2016/04/02/changelog-hierarchy-slicer/.


Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Lydia

     

    Has there been any progress or workarounds with ragged hierarchy visualisation? I have a blank value in a parent child relationship like the graph below. My data hierarchy goes 9 levels down and if I remove the child blank using the visual level filter it begins to exclude data on the prior levels. 

     

    The hierarchy custom slicer allows me to remove blanks in the slicer itself but they still remain in the graph as below. 

     

     

    Thank you. 

     

  • DataExplorer's avatar
    DataExplorer
    Frequent Visitor
    9 years ago

    Thanks Anonymous!