Forum Discussion
Color Coding X-Axis by Year
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?
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:
3 Replies
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:
