Remove blank from hierarchy slicer

[Sunil_arcot]

Hi,

I would like to remove blanks from the hierarchy filter. Tried the page level filter set to "is not blank" and the option in format by selecting not to show blank values. If I am using it few parent nodes are missing because of the blank child nodes.

Before filtering:

After Filtering: (The C Node is missing since the /manager L5 is set not to display blank values)

The resultant o/p needed is:

A-->

    B-->D-->E-->G

    C--> F

Link for the sample .pbix file:  https://1drv.ms/u/s!AuwfGnkRHQJlhztkZAVedHmo2aet?e=yftHkb 

Thanks,

Sunil

[v-xuding-msft · Accepted solution]

Hi @Sunil_arcot ,

The default hierarchy silcer can't remove blank values. You could use the custom visual of hierarchyslicer to have a try.

[amitchandak]

@Sunil_arcot , I think you should create the hierarchy from L5 to L1 . As of now to me it seem from L1 to L5