Conditional formatting based on an indicator in another table

[Brina1210]

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!

[Brina1210]

Hey @kriscoupe , ok thanks! I will keep the value highlighted. Thanks again for responding!

[kriscoupe]

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