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'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.

 

Need Help
Show and Tell

4 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

  • 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.