How to get Area Chart to show months in proper order

[bcbuckley13]

Hello amazing community!

Beginner user here....I'm struggling with getting this Area Chart to show recent months in the correct order. I've tried sorting, etc, but no matter what I do, it shows January as the most recent month.

[bcbuckley13]

I think I was able to get it, but not sure how. I removed everything and redid it.

[MFelix]

Great to see the last image, you can take the quarter out if you don't need it.

[bcbuckley13]

@MFelix I added the year back in and turned of Concatenate, but still have same issue.

[MFelix · Accepted solution]

Hi @bcbuckley13 ,

This has to do with context since you are making it pass during two years but the information is at a Monht / day level the sorting is based on the granularity of the axis in this case month.

If you had the Year in the axis hierarchy and then turn off the concatenate labels you will get the desired output.