Remove blanks at child level ( lowest level) only in Parent-Child Hierarchy

[abhiram342]

Hi Team - We want to remove the blanks at child (lowest level) only and keep the blanks at parent level. I tried with below dax measure but it's not working. Can you please help. 

I used Custom Hierarichal Slicer but it removes the blanks from the parent as well. Example: When User selects Parent Level , currenlty it display all corresponding child entries as well, where as in default slicer there is blank under each parent, clicking on it will provide details for parent Only.

Measure:

_Remove Blanks =

SWITCH(TRUE(),

AND(ISINSCOPE('Pipelines'[L0DisplayName]),ISBLANK(VALUES(Pipelines[L0DisplayName]))),BLANK(),

AND(ISINSCOPE(Pipelines[L1DisplayName]),ISBLANK(VALUES(Pipelines[L1DisplayName]))),BLANK(),

AND(ISINSCOPE(Pipelines[L2DisplayName]),ISBLANK(VALUES(Pipelines[L2DisplayName]))),BLANK(),

AND(ISINSCOPE(Pipelines[L3DisplayName]),ISBLANK(VALUES(Pipelines[L3DisplayName]))),BLANK(),

1)

I used this filter on slicer and filter it to 1 but it's not working. Please assist

Thanks,

Abhiram

[lbendlin]

https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual

[abhiram342]

Thanks @lbendlin ! Is there way to achieve same behaviour in slicer ( default/ Custom Slicer).  Default Slicer provides that functionality but unable to remove blanks from the child. I think I should create dax measure to solve it.

Thanks,

Abhiram

[lbendlin]

short answer is no. That's not how the default slicer was built.  And with the custom slicer you are paying a high price too, as it needs to traverse the entire hierarchy to find the ragged ends. This is all hard work, no magic involved.

[abhiram342]

Thank you @lbendlin