Table Conditional formating based on text column

[dmalviya]

Hi All,

I have one column named EventResult. The possible values are - Success, Fail & Neutral.

I am using simple table to show the values. I want to format Backgrould color of column based on EventResult column.

Success = Green Color

Fail = Red Color

Neutral = Yello

How this can be done? Please suggest.

[Zubair_Muhammad · Accepted solution]

@dmalviya

You can use this MEASURE for conditional formatting.

See attached file as well

Measure =
VAR myEventResult =
    SELECTEDVALUE ( Table1[EventResult] )
RETURN
    SWITCH (
        TRUE (),
        myEventResult = "Success", "#00FDD1",
        myEventResult = "Fail", "#ff2f2f",
        myEventResult = "Neutral", "#ffd62a"
    )