Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

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.