Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.  
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    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. 

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 

ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

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.