Format multiple rows in different colors in matrix visual

[Anonymous]

Dear BI Community,

In the following matrix visual, I have 3 layers of rows starting with fiscal year, gender, and seniority.

What I am trying to do is keep the row header and total for fiscal year in light blue, gender in grey, and seniority in white.

Is there any way to accomplish this? Sincerely appreciate your help with this.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please try to create a measure like below and apply the measure to the conditional formatting of these values:

Measure =
IF(isinscope(financials[Segment]), "white", "#a0d1ff")

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

[amitchandak]

@Anonymous , Create a  measure like this and use in conditional formatting using the field value option. Also use value plus grand total

color = Switch(true() ,

isinscope(Table[Fiscal Year])  || isinscope(Table[Gender]) , "Blue", "White")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4