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