Forum Discussion
Format multiple rows in different colors in matrix visual
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.
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.
2 Replies
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
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.
