Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See my solution in this discussion: Different color for a bar based on Reference Value
See my solution in this discussion: Different color for a bar based on Reference Value
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)
Thank you..