Forum Discussion

Brina1210's avatar
Brina1210
New Member
2 years ago

Conditional formatting based on an indicator in another table

Hello!

I am hoping someone help me out. I have an employee table and an employee activity table which contains a compliance indicator. In my visual (a matrix) I would like to use conditional formatting to highlight the employee name when the compliance indicator is equal to Yes. Right now I when I use conditional formatting it highlights each metric, but I believe it would be easier to for the end users to see the name of the employee’s name highlighted if they are out of compliance (I am also open to suggestions)

 

I would like the final result to look like this

 

 

Rather than this

 

 

thanks!

 

Need Help

2 Replies

  • kriscoupe's avatar
    kriscoupe
    Solution Supplier
    2 years ago

    Hey Brina1210 ,

     

    I do not think you can conditionally format row labels in the matrix visual (one for Power BI ideas!). One way you could display this is using a table visual. Then you are free to conditionally format any field based on values from other fields in the table. You'll lose the cascading hierarchy and it might just be better to have the value highlighted.

     

    Kris