topic Re: Remove blanks at child level ( lowest level) only in Parent-Child Hierarchy in DAX Commands and Tips

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

abhiram342 — Thu, 22 Feb 2024 00:57:35 GMT

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(),

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

Thanks,

Abhiram

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

lbendlin — Thu, 22 Feb 2024 14:52:23 GMT

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

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

abhiram342 — Thu, 22 Feb 2024 17:48:21 GMT

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

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

lbendlin — Thu, 22 Feb 2024 17:59:33 GMT

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.

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

abhiram342 — Thu, 22 Feb 2024 18:24:43 GMT

Thank you lbendlin