Forum Discussion
Visual calculation- Contain
- 3 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 ,
If you get a chance, please review the responses shared by rampie , Kedar_Pande . They have correctly pointed out the key points, so kindly check and let us know if you need any additional details.
Thank you all for your valuable support Kedar_Pande rampie krishnakanth240 .
Regards,
Yugandhar.