Bar charts colors according to the date

[Polux80]

Hi everyone,

I'm stuck with a problem that for sure has an easy answer that is why I need your help.

I ran a type of report weekly and for this I use a Bar Chart with the weekly date in legend :

I've assigned the color by hand according to the date in legend. The problem is that every week, with a new date in the legend, I observe a shift in the colours from right to left with a new color at the right.

I would like to apply a script that said : the last date is always navy blue, the penultimate date is always blue ... in order to have always the same blue gradient.

Could you help me doing that ?

Thank you so much,

Best regards

[Ahmedx]

share an example in the form of pbix with a histogram, and I will try to help you