Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Conditional Formatting based on 2 Field values

Hi, I have a requirement where I need to Conditional Format based upon 2 field values. Tried a lot to implement this, but cant seem to design a rule based upon 2 values. Shown below is a matrix v...

Interesting Links

v-diye-msft
6 years ago
Hi Anonymous

Please try below measure:

Measure = var a = MAX('Table'[Type]) Return IF(a="RF",IF([Delta]>0,"Green","Red"),IF([Delta]<0,"Green","Red"))

Then add it to the conditional formatting on the measure column [Delta]:

Community Support

6 years ago

Hi Anonymous

Please try below measure:

Measure = var a = MAX('Table'[Type])
Return
IF(a="RF",IF([Delta]>0,"Green","Red"),IF([Delta]<0,"Green","Red"))

Then add it to the conditional formatting on the measure column [Delta]: