How to write condition on Bar graph?

[#1]

Hi all,

I need to create a bar graph   in which salary is a dimension.

If salary > 10000 , then I need to show in red or green.

Please post you answers.

--- Arun

[ramoncova06]

under the expresion it has a plus sign "+" click on it to expand it, under background add the condition if(If salary > 10000, red(), green())

[#3]

I don't know why you need to add salary as a dimension.

But if you want to add conditional colouring based on salary, you can go to Chart properties->Expression->expression(click on + icon in expression)->Background Colour -> Definition and write condition as per below example.

=If(Sum(UnitPrice/1000) <= 20,LightRed(),if(Sum(UnitPrice/1000) <40,Yellow(),LightGreen()))

[#4]

Thanks all... Its helpful

[vardhancse]

If you are okay with the solution, please mark the thread as correct answer. So that it might be helpful to others