Hierarchy Slicer

[Anonymous]

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.

[v-alq-msft]

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.

[amitchandak]

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

[Anonymous]

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.

[harshnathani]

Hi @Anonymous ,

You can have a look at this video.

https://www.youtube.com/watch?v=MK1jwHz8hoc&t=42s

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)