How to dynamically set color intervals in a Bar Chart

[Enrique]

Hi does anyones knows how could i set dynamically intervals in a Bar Chart

The requirement is to obtain the boundary values(Gauge Axis Colors) of red, amber and green colors.

it is that possible?

With "Conditional Palette" you can set the color of all Bars with a condition, but its not what i m looking for.

I would like that the Bar change dinamically.

see Attach.


Thanks in advance, Enrique

[hespora]

The only way I got this to work is a hack... you take apart your ratio into as many data items as you have colored regions (in my example, I chose 40 and 70 percent as the borders):

first one:

Code Select Expand

if ([ratio] > 0.4)
then (0.4)
else ([ratio])

second one:

Code Select Expand

case
when [ratio] - 0.4 < 0 then 0
when [ratio] - 0.4 > 0.3 then 0.3
else [ratio] - 0.4
end

third one:

Code Select Expand

if ([ratio] - 0.7 < 0)
then (0)
else ([ratio] - 0.7)

Insert all three data items as series into a stacked column graph, format your series as you want, and done. See screenshot attached.