Forum Discussion

amirabedhiafi's avatar
amirabedhiafi
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Color min and max value in a bar chart

I have the following bar chart :      I want to color the max and the min bar chart with red and green respectively  when choosing any filter. So De Ruyter will be in red and New Britain in...
Need Help
Show and Tell
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    5 years ago

    Hey amirabedhiafi ,

    the conditional formatting has moved :-), I'm sorr for the inconvenience. Here you can add the measure that colors the min and the max value:

    Hopefully, this is what you are looking for.

     

    Regards,

    Tom

Johanno's avatar
Johanno
Icon for Continued Contributor rankContinued Contributor
5 years ago

To set color by value depending on the filtered value, create a measure like:

 

Color coding = 
SWITCH (SELECTEDVALUE('Table'[Country]),
        "New Britian", "#00ff00",
        "De Ruyter", "#ff3300"
)

 

 

Then set color by using fx - format by "Field value" - Based on field Color coding (or the name of the measure)

 

Is that answer to the question?

leojhernandez's avatar
leojhernandez
Icon for Helper I rankHelper I
2 years ago

How do you do this using a maximum and minimum variable? Suppose "New Britian" is the minimum, and vice versa.