How to remove the blank/null for a hierarchy from a slicer.

[Anonymous]

I want to remove the Blank at DM & MC level (Marked in red) with out impacting DO level in Hierarchy slicer. Because, there is some calculation based on that. Is there any possible ways? I tried removing the blank from filter. but, it is impacting the DO level as well. If I removing the null values / blank in DM & MC, the region is also getting vanished. Please help!!!!

[Greg_Deckler]

@Anonymous One way would be to create three new columns and use those in your hierarchy.

Level 1 = [Region]
Level 2 = IF(ISBLANK([DM]) && ISBLANK([MC]),[DO],[DM])
Level 3 = [MC]

[Anonymous]

This is not coming as expected. 😥

[Greg_Deckler]

@Anonymous Not sure what is not expected/problem. Attached a PBIX below signature if perhaps it helps.

[Anonymous]

@Greg_Deckler  is there any way to remove the null / blank from level 3 as well. because when I am trying to remove it. many items are also getting lost. 

[Icey · Accepted solution]

Hi @Anonymous ,

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

Reference: Solved: Remove blank from hierarchy slicer - Microsoft Power BI Community

Please note that it will both remove the blank values and non-blank value under it.

Best Regards,

Icey

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

[Anonymous]

@Greg_Deckler Thanks for your quick solution. Will try to work with this turn around. however, a blank / null is coming in Level 3 level (Marked below). Our requirement is also to remove that as well.