Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Formatting based on table

Hey everyone, I've got the following table: I'd like to format the first two columns conditionally: If the of Totaal Omzet is less then Prognose Omzet, then the value should be red. Othe...
Need Help
  • Saap's avatar
    Saap
    4 years ago

    Hi Anonymous 

    You can create simple measure to check if prognose is higher than total:

     

    check = IF(SUM('Table new'[Prognose])>SUM('Table new'[Total]),1,0)
     
    Then you go to matrix's visual settings, cell elements and apply background color based on your measure:

     

Saap's avatar
Saap
Icon for Resolver III rankResolver III
4 years ago

Hi Anonymous 

You can create simple measure to check if prognose is higher than total:

 

check = IF(SUM('Table new'[Prognose])>SUM('Table new'[Total]),1,0)
 
Then you go to matrix's visual settings, cell elements and apply background color based on your measure: