Conditional Formatting

[Kadrimedquali]

HI ALL, 

i have a problem in my dashbord 

• I want when the column ( Coût /kg) is greater than the (obj export) column = 0.34 in red or icon red
• I want when the column ( obj export) is greater than the (Coût /kg) column = 0.34 in green or icon green

thanks

[ERD · Accepted solution]

@Kadrimedquali , you can use Conditional Formatting for your table. One of the ways to achieve the result:

1. Create a measure like 

Measure = IF( SUM('Table'[Column1]) > SUM('Table'[Column2]), 1, 0)

2. Format table - Conditional formatting - Background

3. Choose format by rules based on measure:

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Kadrimedquali]

i need your help