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

Hi NikhilChenna 
If the 14,15 and 16 is the single column then what is the dax function, Please advise

NikhilChenna's avatar
NikhilChenna
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Hi Anonymous ,

You can try the below ,

=IF([Value] <> EARLIER([Value]), 1, 0)

Regards,

Nikhil Chenna

If your issues resolves select my post as a solution and gives a thumbsup.