Forum Discussion
Solved
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 h...
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:
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:
