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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 months ago

Vasudeva-cv19 So why not a selector measure like the following? 

Selector Measure =
  VAR __Level_3_Team = SELECTEDVALUE( 'Table'[Level_3_Team] )
  VAR __Level_4_Team = SELECTEDVALUE( 'Table'[Level_4_Team] )
  VAR __Level_5_Team = SELECTEDVALUE( 'Table'[Level_5_Team] )
  VAR __Result = IF( __Level_3_Team = BLANK() || __Level_4_Team = BLANK() || __Level_5_Team = BLANK(), 0, 1 )
RETURN
  __Result

 

Put that measure in your Visual level filter and set the filter to equal 1. Then the unwanted rows should disappear from the matrix.

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

Hi Vasudeva-cv19,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you Greg_Deckler for the prompt response. 

 

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

 

Thanks and regards,

Anjan Kumar Chippa

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

    Hi @Vasudeva-cv19,

     

    We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • Vasudeva-cv19's avatar
      Vasudeva-cv19
      Regular Visitor
      8 months ago

      No its not working 

      • 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