bar chart coloring depending on variables

Hi,

currently i’m struggeling with color management at my latest views.

I want to use custom colors at a bar chart depending on values OR column name. 🥲

Since a new data set is added every month, the coloring always changes.

In this Example i colored the Rows by hand. I would like to plot 2022 versus 2023 on a monthly basis.

2022 = grey

2023 = blue (company color)

I tried to manipulate the color model but coudln’t find a solution.

Coloring via Variables also didn’t work because the input changes…

So i ran out of ideas…