Forum Discussion
Custom Column - add font color
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
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.
1 Reply
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.