How to remove a blank from Hierarchy in Matrix Visual

[Anonymous]

Hi All ,  

I tried to create a hierarchy based on 9 LEVEL of Data and I need show a lowest level of each hierarchy as various ACTIVITY NAME under that level.

While tried to create this hierarchy I'm seeing blank data , When trying to remove blank using ISINSCOPE function the lowest hierarchy is not showing.

SampleFile.pbix 

Please find out the expected file Here ,

For expected output I'm showing the data in different column without blank but I need to show the same data in same column.

[rajendraongole1]

Hi @Anonymous 

can you please try below measure

I have used below condition.

_Remove Blanks =

SWITCH(TRUE(),

AND(ISINSCOPE(Sheet1[Level 1]),ISBLANK(VALUES(Sheet1[Level 1]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 2]),ISBLANK(VALUES(Sheet1[Level 2]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 3]),ISBLANK(VALUES(Sheet1[Level 3]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 4]),ISBLANK(VALUES(Sheet1[Level 4]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 5]),ISBLANK(VALUES(Sheet1[Level 5]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 6]),ISBLANK(VALUES(Sheet1[Level 6]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 7]),ISBLANK(VALUES(Sheet1[Level 7]))),BLANK(),

AND(ISINSCOPE(Sheet1[Level 8]),ISBLANK(VALUES(Sheet1[Level 8]))),BLANK(),

1)

with visual level filter with 1.

Please check and let us know

Hope it works in your scenerio

Regards,

Rajendra

[Anonymous]

Based on above measure blanks are removing but data's are not showing as expect to dataset

Please be find out the expected file Here ,

For the expected output I'm showing the data in different column without blank but I need to show the same data in same column.

[Ahmedx]

Hi, I honestly did not understand what you need. you can show the result and how you applied the ISINSCOPE functions

[Anonymous]

As shown above image you can see the blanks in hierarchy that blanks I need to remove