No this is not possible with the Coloring based on Series. You could try to add the formula as an extra dimension. and try to color based on dimension instead of series.

However, I am not sure whether that would work 100%.

I found a way, we can use variables

Yes, my bad. I saw it and didn't remember that was palettes.

You can change the thresholds for the Colors in Celonis in three ways (that I am aware of):

• PQL in Gauge, number, etc...
• Use Variables in Palettes - i.e. OLAP tables and the like (probably you will need a KPI to set up the variable dinamically)
• Variables with the hex code of a color, set by KPIs, to use with Text - with the color= \\color tags of HTML.

Hello Raman, how did you do it? I try to do the dynamic color mapping based on the other KPI of the bar chart.