Conditional Format Data Lables Field Value

[Janica123]

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 dropdown box for 'What field should we base this on?' is outlined red, and it doesn't let me select my measure.

This is how my measures looks like:

%Change_Tagessatz =
VAR Change =
DIVIDE(
[Ø Tagessatz] - [Ø Tagessatz_LY],
[Ø Tagessatz_LY]
)

RETURN
FORMAT(Change, "0.0%")

%Change_Tagessatz_Color = IF( [%Change_Tagessatz] > 0, "Green", "Red")

In the dropdown box I want to put the 2. measure (%Change_Tagessatz_Color)

Any ideas?

[gmsamborn]

Hi @Janica123 

I noticed a problem with your measures.

When you format the result using FORMAT, it returns a text value which you won't be able to compare to zero in your second measure.

Format the measure using the formatting ribbon if required.

[rajendraongole1 · Accepted solution]

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.