Forum Discussion
Solved
Conditional Format Data Lables Field Value
Hi, I'm trying to conditionally format the data lable of a column chart, based weather the value is positive (green) or negative (red) However, when trying to format based on 'Field Value', the dro...
Hi Janica123 -You need to create a measure that returns a numeric or color code value. The best approach is to use color codes (Hex or RGB) instead of text
link:
Color Hex Color Codes (color-hex.com)
%Change_Tagessatz_Color =IF([%Change_Tagessatz] > 0,"#00FF00", // Green in Hex"#FF0000" // Red in Hex)This measure returns the Hex color code for green when the value is positive and red when the value is negative.In the "Based on field" dropdown, select your measure.
Hope it helps.
