Forum Discussion
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 visual and the rules.
| Type | PC | RC | Delta |
| RF | 90 | 100 | 10 |
| IF | 70 | 60 | -10 |
| OOG | 50 | 30 | -20 |
| ZF | 40 | 60 | 20 |
Here RF, IF, OOG, ZF are row values for field "Type" & PC, RC, Delta are calculated measures(grouped by "Type").
Is it possible to achieve the following using conditional formatting feature ? Should I design a measure to achieve this ?
If Type = 'RF' & Delta >0, then "Green" else "Red"
If Type <> 'RF' & Delta <0, then "Green" else "Red
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]:
3 Replies
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]:
Anonymous - You could create the following Measure, and it as the Field Value in conditional formatting:
Color = var _Type = max(Conditional[Type]) var _Delta = sum(Conditional[Delta]) return IF( _Type = "RF", IF(_Delta > 0, "Green", "Red"), IF(_Delta < 0, "Green", "Red") )I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.Anonymous you can surely do this by writing a measure with the logic for color and return the color name as value, and then use this measure in conditional formatting to set the color for Delta.
