Forum Discussion

Anonymous's avatar
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
Need Help
  • v-diye-msft's avatar
    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]:

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.