bar chart x axis show MMM-YY for multiple years without adding them up by month.

[mtp03]

I have data that spans to 2019. I need to be able to see the month axis change from any point. The problem is if I select months in different years, it sums them up under 1 month category. 

Looks like this with 2 years selected (I want Jan 21, Feb 21, Mar 21... May 22, June 22, July 22, etc.); ignore the colors that show certain categories of data and not the year designation:

This is how I have the bar chart axis pulling. I know I probably need another table or something but I cannot figure it out.

[v-xiaotang]

Hi @mtp03 

Thanks for reaching out to us.

you need to add year into axis, otherwise it will not correctly identify which year the same or different months should belong to.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[mtp03]

I have tried that two ways but it ends up summing up all 2021 in one bar and all 2022 in one bar:

Can you explain what you mean by add the year into the axis?