Conditional Formatting based on 2 Field values

[bibhu250]

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

[v-diye-msft · Accepted solution]

Hi @bibhu250 

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]:

[parry2k]

@bibhu250 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.

[Anonymous]

@bibhu250  - 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.