How hide multiple text fields used into the value section of the matrix visual while collapsing rows

[V_Ramugade]

Hi All,

I am working on the one the report in power bi, where I need to control the visibility of multiple text columns used into the value section of the matrix visual while expanding or collapsing the row fields.

However I can achieve the same through single measure with use of ISINSCOPE & SELECTEDVALUE functions for individual text fields used in matrix visual.

I had also tried another approach with single measure for row field used in ISINSCOPE function and applied same measure for the text fields conditional fomatting but at the total row text fields get visible. So, that approach also not work as expected.

However, I want a single measure that can be work for all text field used into the value section of the matrix visual and get hide when collapsing all row fields. 

Please refer the below screen shots. where you can see the matrix 2 work fine with individual measure while collapsing all row field. but with conditional formatting method text field appear while collapsing all row fields in matrix 4.

[Anonymous]

Hi @V_Ramugade ,

Here is my solution:
Use this DAX to create a measure:

DisplayColumns = 
IF(
    ISFILTERED('Product'[ProductID]),
    "black",
    "white"
)

Then set the conditional format of the column ProductCategory, column Territory and column Location:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V_Ramugade]

Hi @Anonymous ,

Really appreciate your responce. but since into my actual report there is a backgroud colour set for the matrix visual and because of that matrix showing filtered rows like below. It would be really helpful if you can provide solution for the same. Thanks in advance.

[Anonymous · Accepted solution]

Hi @V_Ramugade ,

I'm sorry, but I don't understand what you mean. Don't you want these data to be invisible before expanding to the ProductID layer?

But this has nothing to do with the background of the matrix you set, because the background of your matrix cells is white. You should still set it to white instead of setting it to the background color of your matrix #E8F4FC.

Did I misunderstand your meaning?

Best Regards,
Dino Tao

[V_Ramugade]

Hi @Anonymous ,

Thanks for helping me for this issue. 

No, you didn't misunderstand. But I didn't put all the details and because of that you may get confuse.
Sorry for the same.

Actually there is a pre defined matrix formatting set and over there background colour for row total, column total is set to #E8F4FC and that's why it was not work as expected but as you mentioned one measure for Font colour same way I have created another measure for background colour and that's work.

Now, Since I want only single measure to work with multiple dataset. Hence  I included all the required dataset withing ISFILTERED fuction with OR function and that is working as expected for all the other dataset as well.

Thanks for your support.