Ordering dates, grouped by month, by year

[hoss]

Hi there,

Almost newbie here.

I have a ribbon chart and on X axis I'm showing count of date values for each user in the last six months (each colour is a user). I want to group the data in months so in the fields I'm choosing date hierarchy and remove year, quarter and day. It works good but the problem is that the order of x axis now disregards the year. For instance instead of being Nov(2019), Dec(2019), Jan(2020), Feb(2020), it is Jan(2020), Feb(2020), Nov(2019), Dec(2019).

If I include the year the values will be grouped by year as below which is not what I want:

If you may need other things to be able to answer the question let me know.

Any help is much appreciated.

[amitchandak · Accepted solution]

have you used month year that sorted correctly?

example

month year = Format([Date],"MMM-YYYY")

month year sort = Format([Date],"YYYYMM")