Forum Discussion
Visual calculation- Contain
Hi good day can anyone help me on my visual calculation. May colunm status contain 'OVERDUE". What i required is to turn red the word "OVERDUE"
Thank you
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.
5 Replies
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.
Hi AllanBerces
Color =
IF(
CONTAINSSTRING([Status], "OVERDUE"),
"#FF0000",
"#000000")
Conditional Formatting - Font Color - Format by Field Value and select field
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.
Hi AllanBerces ,
Could you please confirm if your issue has been resolved, or if you still need any additional details or clarification from our side.
Thank you.
