Forum Discussion
Conditional Formatting - Matrix Table
Hi Team, I have below table and created Matric table in PI file, now I need to highlight rows wise if value mismatch.
So if I understood correctly all values in the same category should be the same, otherwise be highlighted. Find attached my proposed solution. I adapted NikhilChenna 's recommendation into this formula:
Color Logic = IF(SUM('Table'[Cat14]) <> SUM('Table'[Cat15]) || SUM('Table'[Cat14])<> SUM('Table'[Cat16]) || SUM('Table'[Cat15]) <> SUM('Table'[Cat16]), "#FF7F7F", "#FFFFFF")You would need to pivot your table though, assuming you don't have other data.
ray_aramburo
Super User
Super UserWhat would be the criteria to determine if a value is a mismatch?
Hi ray_aramburo
Entire row highlight amber color
- ray_aramburo
Which values do you want to compare I meant?
- ray_aramburo
So if I understood correctly all values in the same category should be the same, otherwise be highlighted. Find attached my proposed solution. I adapted NikhilChenna 's recommendation into this formula:
Color Logic = IF(SUM('Table'[Cat14]) <> SUM('Table'[Cat15]) || SUM('Table'[Cat14])<> SUM('Table'[Cat16]) || SUM('Table'[Cat15]) <> SUM('Table'[Cat16]), "#FF7F7F", "#FFFFFF")You would need to pivot your table though, assuming you don't have other data.