Forum Discussion

Vasudeva-cv19's avatar
Vasudeva-cv19
Regular Visitor
9 months ago
Solved

Having issue with Ragged hierarchy in matrix visualization

In Power BI, we are trying to create a hierarchy for organizational roles (e.g., Level 1 → Level 2 → Level 3 → Level 4 → Claim Team → Handler). However, the data is not uniform: Some records only h...
Need Help
  • v-achippa's avatar
    v-achippa
    8 months ago

    Hi Vasudeva-cv19,

     

    Thank you for the response. This behaviour is expected because the Matrix visual does not support true ragged hierarchies. Unfortunately it cannot hide empty hierarchy levels automatically and no DAX filter can override that behaviour.

    To display the hierarchy without blanks, the data needs to be reshaped so that only the levels that actually exist are used in the visual. Please follow below steps:

    • Use Power Query and unpivot Level_1 to Level_6 and remove the blank values. This shows a clean parent-->child structure and the Matrix will show the hierarchy correctly without empty spaces.
    • If you cannot change the shape, please create a single Path column like combine only the non-blank levels into a single text for example like Vasudeva > Mayur > Caarly > ADAMAS. Then use this Path column in the matrix or table. It avoids all blank levels because the path is built only from existing values.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
8 months ago

Hi Vasudeva-cv19,

 

Thank you for the response. This behaviour is expected because the Matrix visual does not support true ragged hierarchies. Unfortunately it cannot hide empty hierarchy levels automatically and no DAX filter can override that behaviour.

To display the hierarchy without blanks, the data needs to be reshaped so that only the levels that actually exist are used in the visual. Please follow below steps:

  • Use Power Query and unpivot Level_1 to Level_6 and remove the blank values. This shows a clean parent-->child structure and the Matrix will show the hierarchy correctly without empty spaces.
  • If you cannot change the shape, please create a single Path column like combine only the non-blank levels into a single text for example like Vasudeva > Mayur > Caarly > ADAMAS. Then use this Path column in the matrix or table. It avoids all blank levels because the path is built only from existing values.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
8 months ago

Hi @Vasudeva-cv19,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa