bar chart color based on threshold

[#1]

hi all,

      i have my bar chart having threshold which shows avg(value).i had given the condition in the expression for the background color of bar chart like color blue if less than 400 else red.its working fine.

But my question is can i show blue color on the bars(red) which are below the green line? that is like this

[Gysbert_Wassenaar · Accepted solution]

See my solution in this discussion: Different color for a bar based on Reference Value

[whiteline]

Hi.

For almost static charts you can create two objects: background 'red' chart and transparent overlay 'blue' chart.

Another way, create additional Calculated dimension: ValueList(1,2)

And expression that splits the values:

=pick(rowno(), RangeMin(Value, 400), RangeMax (Value, 400)-400)

[#4]

Thank you..