Color Coding X-Axis by Year

[mwalden]

I am working on a stacked column chart, where I want to customize the colors based on both the legend information and the x-axis information. Here is as far as I've come:

As you can see I have the x-axis split in 2022/2023 by Month, and in the legend I have "Nature of spending":

What I would like to do, is have the colors be different for 2022 and 2023. It's not very obvious in the current layout, that it's two different columns per month. But I can only speficify the color based on the legend. 

Any ideas on how to do this? - Without having to pay for a custom visual developed by third party?

[olgad · Accepted solution]

Hi, may be you can make 4 measures. Provided you always show the current and the previous year. 

Calls (2023)= Calculate(Count(Calls)), 'Date Table'[Year]=Year(Today()))
Calls (2022)= Calculate(Count(Calls)), 'Date Table'[Year]=Year(Today())-1)
 and the same for emails, then you will get something like this: 

[mwalden]

Do you put the measures in the Y-Axis? this is the error message I get for each of them

[mwalden]

Nevermind - I got it to work! thanks so much!!!!