Forum Discussion

Russo's avatar
Russo
Helper I
11 months ago
Solved

Conditional formatting for guage color vs. target

Hello,

 

Is it possible to set my guage color to green if > target value and red if <.  I'm using measures to get my values, so no table data.  How would I achieve this if possible?

 





  • MasonMA's avatar
    MasonMA
    11 months ago

    Hello Russo 

     

    You’ll need a DAX measure that returns a color name or hex code based on the comparison:

    IF([ActualValue] <= [TargetValue], "#00B050", "#FF0000")

    Set up the 'Fill Color' in Format Pane with this Measure as Field value. 

            

     

     

     

     

2 Replies

  • MasonMA's avatar
    MasonMA
    Super User
    11 months ago

    Hello Russo 

     

    You’ll need a DAX measure that returns a color name or hex code based on the comparison:

    IF([ActualValue] <= [TargetValue], "#00B050", "#FF0000")

    Set up the 'Fill Color' in Format Pane with this Measure as Field value.