Hide blanck value in hierarchy level

[Anonymous]

Hi Power BI community,

I am facing an issue which i tried to find a solution using INSCOPE dax function without any success.

My issue is that i am using a matrix with 3 levels row hierarchy

Let say that i have 

level 1

  Level 2 

     Level 3 

Level 2 had some Blanck values but level 3 attached to this level 2 have no balcnk values which means that i would like only to show Level 1 

             level 3 

when level 2 have blanck value

I tried to use a measure combining SWITCH and IS INSCOPE AND BLANCK at LEVEL 2 but it hide level 2 and level 3 also when level 2 have blanck value.

Thank you 

[Anonymous]

Thankyou @Pragati11 solution founded in the link provided.

I also used the solution provided by Curbal channel in youtube available in the link : https://www.youtube.com/watch?v=YEuxONjCl1A&t=370s

Many thanks 

[Anonymous]

Hi @Anonymous ,

Are the similar threads provided by @Pragati11  helpful to you?

If not, is it possible to provide some dummy data and expected results?

Best Regards,

Stephen Tao

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

[Pragati11 · Accepted solution]

Hi @Anonymous ,

There are some existing threads on the forum for this. See if they help:

https://community.powerbi.com/t5/Desktop/Hide-Blank-at-the-2nd-level-of-hierarchy-in-matrix/m-p/2021007

https://community.powerbi.com/t5/Desktop/Hide-Blanks-Values-in-Matrix-Hierarchy/m-p/648253

Also always make sure, you add details to your query like screesnshots, sample data, etc.