change of color on barchart

[t_hylander]

Hi,

Have a simple combochart showing result vs budget with full ackumulation;  (bars is result, and line budget)

What Id like is that bars after july (since aug numbers isnt in yet) should be a diffrent shade. Ofcourse this should be dynamic so when its september, then okt and onward should be a diffrent shade.

Made a small example with just the core numbers if you need something to play around with.

Thanks in advance!

[sunny_talwar · Accepted solution]

Try a background expression like this

=If(Month(Date#(Only({1} Month), 'MMM')) < Month(Today(1)), RGB(154, 198, 188), ARGB(100, 154, 198, 188))

[Anil_Babu_Samineni]

Try this as BG color?

If(MonthNum <= Num(Month(Today())), Green(), Yellow())

Where as MonthNum created by script like Num(Month(Date#(Month,'MMM')))

[t_hylander]

Thanks!

Just what I wanted.