Custom Column - add font color

[jerryr125]

Hi - 

In a table I created a Custom Column (TOPERCENT).

The Custom Column Formula is as follows:

[StoreName] &
(if [OverDuePercent]> 0 then
" (Overdue: " & Number.ToText([OverDuePercent]) & "%)" else "")

Which works, But is there a way you can set the " (Overdue: " & Number.ToText([OverDuePercent]) & "%)" to a specific font  and/or color so that it appears in the visualization (such as #ff0000")  ?

Thanks - Jerry

[danextian · Accepted solution]

Hi @jerryr125 

You can create a measure that checks the curent row value of your custom column and return a specific font color.  I'm not sure what the exact condition is, may be if it contains the word overdue

conditional formatting color =
IF ( CONTAINSSTRING ( 'table'[custom column], "overdue" ), "#ff0000" )

Now add your custom column to a table viz and then conditionally format it. Select field value from the options use the measure from above.