Forum Discussion
Conditional formatting for "rows" in matrix visual?
If I understood this correctly, I got around it by creating a computed column -- let's call it "ColorPicker".
In my instance, my Matrix has 3 rows of data (and multiple columns), the rows and their respective headers are:
StatusA (row 1)
StatusB (row 2)
StatusC (row 3)
My colorpicker computed column (which is a Nested IF) basically indicates that in my source data:
IF I come across StatusA, assign colorpicker a value of 1
IF I come across StatusB, assign colorpicker a value of 2
IF I come across StatusC, assign colorpicker a value of 3
Afterward, I apply conditional formatting to the Values within the matrix via:
Format by Rules
Based on field (Min of ColorPicker)
Setup 3 rules:
If value is 1 (number) then Green
If value is 2 (number) then White
If value is 3 (number) then Yellow
Now each respective row of the Matrix has its own color.