Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Praiciya-13
Frequent Visitor

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.

image.png

 

4 REPLIES 4
rajendraongole1
Resident Rockstar
Resident Rockstar

Hi @Praiciya-13 

 

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

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
Super User
Super User

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

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.