Color in bar Chart depending on prefix

[#1]

Hallo,

i have the following Problem:

I have a bar chart, with e.g. the Return on Investment (ROI) .

My dimension is a Drill-Down group, like company, Produkt, ...

and i want the graph to be red, if the ROI ist negative,

and the graph to be green. if the ROI is positive.

I tried it, like :

Colors, pick up the first color and put into the following

formula: if (sum (ROI)>0 , green(),red())

But the graphs allways are green or red at all,

not like wanted.

So is there anybody,who may help me (if there is anybody who

speaks German,....that would be nice;)

Thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Go to the Expressions tab, and expand clicking on the [+] sign at the left of the expression you want to change. You will see "Background Color". Set the condition there.

Hope that helps.

[#3]

Thanks,...it works,...i looked at the wrong place 😉