Change the color of the chart based on the objective

[Anonymous]

Hello,
I created a chart of grouped columns and lines that shows production quantity values ​​for each different machine. I also created a measure that is being used as an objective for each machine (the black line). My chart looks like this:

Both, the value of the chart and the objective line, is correct, but how can I set to change the color of the bar whether the machine's objective has been achieved or not?
Example: for machine 315, the bar should be green, but for machine 110, the bar should be red. How do I do that?

[OwenAuger · Accepted solution]

Hello @Anonymous 

You can create an additional measure calculating the difference (or the sign of the difference) between [Qtd.] and [Objective] and use that as the basis for conditional formatting of the bars.

Attached is an example, where I created a measure:

Surplus = 
[Qtd.] - [Objective]

Then I set conditional formatting for Default Color (which is the bar color) as follows:

Result looks like this:

Regards,

Owen

[Anonymous]

This is amazing! Thanks!