Perspective - XY Charts column colors - Conditional

[Alexandre_Rousselet]

Hello,

I am working in Perspective to setup some XYcharts on my dashboard.

I am trying to setup an XY column chart with column styles for each x value depending on their respective y values.

For example on the chart below, my reference would be the red line value. If under I would be columns would be red, if over, columns would be green.

I am already able to change the whole series colors based on that, but still not able to do that per column.

Any idea in which properties of my XYchart I would be able to find this value?
Any idea if such setup is possible, and if not, should I just split this in two series (1 red, 1 green)

Thanks,

Alexandre

[CalebM]

You will want to use the deriveFieldsFromData property.

You'll need to add a property to set the color with for each data point. You will want to set this property based on the value.

Then you will need to add the name of the property to the deriveFieldsFromData. You could use multiple properties if you wanted different fill and stroke colors.