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
Anonymous
Not applicable

Collapsed Matrix to Show Blanks Using Measure Names

Hello,

 

I am trying to show blanks for my collapsed matrix visual rather than visuals. I understand that can be done using ISINSCOPE, however the column I'm trying to show blanks for is based off of a measure. Can anything be done?

 

Thank you in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @amitchandak,

Thank you so much for the response! It doesn't quite work, and I probably should have been more specific with my question. I wanted a measure that would show blanks rather than values for the collapsed matrix. (Refer to below image)

Crystal77_0-1648571034346.png

However, when the matrix is exanded, I didn't want those values to also be blank. (Refer to the below image. Also, please imagine the crossed out values are populated. The info is sensitive, so I couldn't just leave it there.)

Crystal77_2-1648571301696.png

 

Maybe I did something wrong, but when I input the measure with my fields, both the expanded and collapsed matrix values show up as blank. However, it was a great hint that led me in the right direction.

 

The solution I came up with is as follows:
IF( ISINSCOPE( 'Table'[Column1]) && NOT( ISINSCOPE( 'Table'[Column2])), BLANK(), [Measure])

 *As a side note for anyone else needing help with this, column1 is from the first value in the row field of the matrix, and column2 is the second value in the row field of the matrix. The measure is the original measure that originally didn't have the blanks in the collapsed matrix.

 

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hello,

 

I have similar issue where in i am using info river visual for matrix view. I have a mtrix with sub filters upto 3 levels. I want each level to display a defined static number when collapsed rather than in built sum up by the tool.

 

sizi_1-1686121265796.png

As given in the screenshot , there's main level which when collapsed shows 865 and under the filter i have sub level filter as radio/connected devices etc which has its own statement under them with different values. I want to display static number for connected devices eg 750 instead of aggregating the total value based on statement under the filter. So basically connected devices to show 750 ,radio 150 etc when collapsed.

Is there anyway i can achieve this? column field is Number & Percentage based.

 

Thanks in advance.

amitchandak
Super User
Super User

@Anonymous , You can check like

 

if(isinscope(Table[Column]) && isblank([Measure]) , <>, <> )

Anonymous
Not applicable

Hi @amitchandak,

Thank you so much for the response! It doesn't quite work, and I probably should have been more specific with my question. I wanted a measure that would show blanks rather than values for the collapsed matrix. (Refer to below image)

Crystal77_0-1648571034346.png

However, when the matrix is exanded, I didn't want those values to also be blank. (Refer to the below image. Also, please imagine the crossed out values are populated. The info is sensitive, so I couldn't just leave it there.)

Crystal77_2-1648571301696.png

 

Maybe I did something wrong, but when I input the measure with my fields, both the expanded and collapsed matrix values show up as blank. However, it was a great hint that led me in the right direction.

 

The solution I came up with is as follows:
IF( ISINSCOPE( 'Table'[Column1]) && NOT( ISINSCOPE( 'Table'[Column2])), BLANK(), [Measure])

 *As a side note for anyone else needing help with this, column1 is from the first value in the row field of the matrix, and column2 is the second value in the row field of the matrix. The measure is the original measure that originally didn't have the blanks in the collapsed matrix.

 

 

 

Helpful resources

Announcements
Europe Fabric Conference

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors