Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hierarchy Slicer

Hi All,

 

I have created the hierarchy in my report and want to use it in the hierarchy slicer(Custom Visual).

The data contains as below:

Level1  Level2  Level3 Level4

0          1000     1100   2

0          1000     1100   3

0                       1200   4

0                                  5

 

If I have selected the Hide Members as Empty in Selection Pane, it only shows the first two records and hides all the remaining records completely.

 

Please help me to display all the records by only hiding the blank leaf.

 

Thanks.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , why level 2 is empty when you have value at levels 3 and 4 ?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak,

       

      I have calculated the hierarchy path using path function. And the path is up to 4 levels depend on the users available in the organization, the users in the organization structure as below:

      1. Corporate User

      2. Banner User

      3. Region User

      4. Store user

       

      We have also used the embedded environment for Multitenancy (Single report and multiple datasets per tenant).

       

      In the report, I have used all four columns in the hierarchy. 

       

      The problem here is that, if in any tenant having only users type as 1,2,4 or 1,3,4 or 1,4 then one or two columns remain blank and it shows the blank entry in the Hierarchy.

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    If you select the 'Hide Members' as Empty in Selection Pane, it hides the current level and the levels after the current level where the current level is empty. 

     

    'Hide Members' is to control if items should be hidden to support 'ragged hierarchies'.

    • Never - Never hide members
    • Empty - Hide items if the value is 'empty'. See '' strings are empty option for additional options
    • Parent Name - Hide items if the value is the same as the parent value

     

    For further information, I'd like to suggest you refer to the following links. 

    Power BI HierarchySlicer 

    HierarchySlicer 

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.