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. Otherwise green.

Is there a way to do this?

With kind regards,

Lazzanova

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:

     

1 Reply

  • Saap's avatar
    Saap
    Resolver 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: