Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Hierarchy

Hello Friends, I have a requirement in one of my reports. Trying to convert from SSRS to the awesome Power BI reports. I have a report which has different category  1. Products 2. Country 3...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Sorry for the delay in seeing this but issues at work. 

     

    Althoiugh I have seen some links to make the hierarchy slicer change they are based on values with the same table:

     

    https://xxlbi.com/blog/dynamic-hierarchies-in-power-bi/

     

    Believe that your options is to create 3 matrix visuals one with each hierarchy level order, then create a bookmar for each one and hiding the other two tables then just add buttons and link them to the bookmarks.

     

    Check example attach.

     

     

    Regards,

    MFelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi MFelix

 

Appreciate the update. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

MFelix any help on this is much appreciated ?

 

 

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Anonymous,

     

    Sorry for the delay in seeing this but issues at work. 

     

    Althoiugh I have seen some links to make the hierarchy slicer change they are based on values with the same table:

     

    https://xxlbi.com/blog/dynamic-hierarchies-in-power-bi/

     

    Believe that your options is to create 3 matrix visuals one with each hierarchy level order, then create a bookmar for each one and hiding the other two tables then just add buttons and link them to the bookmarks.

     

    Check example attach.

     

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      MFelix

       

      That is just the exact solutions I was looking for. Thanks a ton. You are a true datanaut.

       

      I will definitely consume this . 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi guys. I know I'm 2 years late to the party however . . I found this YouTube video by Parker from Bi Elite. The reason for mentioning it here is that this community post is always found in the top spot in Google's search results whenever someone searches for 'Dynamic hierarchies in Power BI'. I recently faced the obstacle Anonymous did. So I followed the process mentioned in the video. Although there's a different kind of problem I'm facing . .

         

        The functional hierarchy I have in my dataset has 3 levels. Now, ideally, I should only inlcude 2 chiclet slicers (I assume you have watched the video, it's quite informative) & Power BI should automatically show rows from 3rd level of hierarchy when I expand down to the last level. I does do that except when I have expanded ALL the levels, in the rows for last level (within the matrix visual), I get repeated data from most recent levels. How do I get rid off of those extra rows ? I'd also like to mention that if I insert another slicer for the 3rd (implied) level in hierarchy (whatever that may be), then the redundant rows do not appear.

         

        P.S. : Apologies in advance if this sounds confusing but this is my first post in Power BI Community 😅 & I cannot post images or any sort of data due to confidentiality issue. ¯\_(ツ)_/¯