Conditional formatting all values using text condition

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