Bar Chart

[mwallman]

Hi,

In a chart I would like to change the colour of the line when it is above the reference line. E.g. to Red.

Anyone know how this is possible please?

[Clever_Anjos · Accepted solution]

Use this as backgroundcolor expression

if(

Count(DISTINCT OrderID) <

Avg(total Aggr(Count(DISTINCT OrderID), MonthYear)),

LightRed()

)