Forum Discussion
Visual calculation- Contain
- 2 months ago
In Power BI you can't directly set a colour on a text value. The way to do it is to base your formatting on a seperate field or measure that returns the colour you want, as described in the docs【920987970406761†L715-L735】.
Here's one way to do it: create a measure that returns a hex code when the status contains "OVERDUE" and something else otherwise, e.g.:
StatusColor =
IF (
CONTAINSSTRING ( SELECTEDVALUE ( 'YourTable'[Status] ), "OVERDUE" ),
"#C00000", // red
"#000000" // black
)Add your status field to the visual, then go to the value dropdown → Conditional formatting → Font color. Choose **Field value** and point it at the StatusColor measure. The word OVERDUE will appear in red and the rest will stay black. You can extend thsi to handle other statuses too.
Add a calculated column or measure that flags the OVERDUE rows, then use conditional formatting on the field's font color.
Color = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[LookaheadStatus]), "OVERDUE"), "#FF0000", "#000000")
That turns the OVERDUE text red and leaves everything else black.