Conditional formatting all values using text condition

[omaffud]

I am trying to do a conditional formatting, but it looks like because of the summarization, it only formats the first value. See condition below. How can I fix that?

[PhilipTreacy]

Hi @omaffud 

Download PBIX file with the example below

You need to create a measure that determines the color, then apply that measure in the Conditional Formatting.

Heres an example measure using Hex color codes, change these to whatever you want.  You can look up Hex color codes online, here's one place HTML Color Picker (w3schools.com)

CF = 

VAR _status = SELECTEDVALUE('DataTable'[Item Status])

RETURN

SWITCH( TRUE(),

    _status = "Cancelled", "#f00",

    _status = "Re-Validated", "#ff0",

    _status = "PL Rejected", "#f0f",

    "#0f0"
)

Then create Conditional Formatting that uses this measure to apply color to the Status column

You can also use well known color names rather than Hex color codes.  See section 4.3 here CSS Color Module Level 3 (w3.org)

Further Reading: see the section 'Color based on a calculation' Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards

Phil

[omaffud]

Phil,

almost there, but as you can see below, most of the times, the color is not being applied.

My code:

StatusColor =

VAR _status = SELECTEDVALUE(QuoteItems[ItemStatus])

RETURN

SWITCH( TRUE(),

    _status = "Cancelled", "#f16a75",

    _status = "Re-Validated", "#00ce00",

    _status = "PL Rejected", "#f16a75",

    _status = "Quoted", "#00ce00",

    _status = "Awaiting PL Review", "#ffcc00",

    _status = "Pending Quote", "#ffcc00",

    "#00ce00"

)

My rule:

Any clue?

Thanks in advance,

Omaffud