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.
Hi AllanBerces
Color =
IF(
CONTAINSSTRING([Status], "OVERDUE"),
"#FF0000",
"#000000")
Conditional Formatting - Font Color - Format by Field Value and select field