How to put conditional formatting on text ?

Hi Anonymous ,

You could create a measure to use numbers to represent different states.

Measyre =
SWITCH (
    SELECTEDVALUE ( 'table'[state] ),
    "Submitted", 1,
    "New", 2,
    "Rejected", 3,
    "Accepted", 4,
    "Closed", 5,
    "Planned", 6
)

Then use the value of measure to create conditional formatting rule.

Best Regards,

Jay