Change color in bart chart, above 0 = green, below 0 = red

[Namoh]

Hi, I've been searching the forum for my issue, but the provided solutions don't show in my report.

Hope someone can help me.

I've got below graph.

The only thing I want is that if a bar is above 0 it turns green, and when it is below 0 it turns red.

I normally do this via Conditional Formatting by right-clicking on the value and select Conditional Formatting but it's not there.

Any other way to achieve this?

[Namoh · Accepted solution]

I found the solution. With this type of chart apparently the right click doesn't work (or they might removed it with an update?). See below which button you need to click, to get the Conditional Formatting option.

[amitchandak]

@Namoh , Do you have something in legend? When you have a legend and more than one measure then it will not come.

[Namoh]

Hi amitchandak, thanks for the quick reply. 

I'm only using one measure.

Where can I find Legend? I'm using the Dutch version but can't find anything related to Legend.