Forum Discussion

Janica123's avatar
Janica123
Helper I
2 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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.

     

     

     

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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.