Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to remove a blank from Hierarchy in Matrix Visual

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'...
Need Help
Show and Tell
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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.