Forum Discussion

brorgustav's avatar
brorgustav
Frequent Visitor
8 years ago

Hierarchy showing levels without nodes

I have googled this, but have not been able to find a solution.

 

I have an hierarchy with different number of sublevels depending on which path you take in the hierarchy.

When I click drill down in the Matrix visual one row is added for each level I want to open, even where there are no sublevels.

 

My issue might be more clear in the screenshot below. There are no sublevels to "Level_2_2" and "Level3_2". But when I want to look 4 levels down (since there are more levels under "Level2_1" and "Level3_1") I get empty rows under "Level_2_2" and "Level3_2" for each level I want to drill down.

 

Is there a way to hide these rows?

Need Help

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi brorgustav,

     

    I don't think there is way hide these rows directly. I would suggest you add it as an idea on Power BI Ideas forum to improve Power BI on this feature. 

     

    In addition, an alternative option is to turn off "Stepped layout" and "Row subtotals" which should somehow hide the rows. :smileyhappy:

     

     

    Regards

    • brorgustav's avatar
      brorgustav
      Frequent Visitor
      8 years ago

      Thanks v-ljerr-msft I'll give that a try and see If I can get my matrix to look better.

       

      I have found some more info regarding this and as I understand it this is solved in SQL Server AS 2017 (Compatibility level 1400). 

       

      Actually when I wrote my post yesterday I did not know that this was called "Ragged Hiererchy". It's easer when you know what to google :)