How to get month and year sorted in the same chart

[jbrolland]

Hello

I am running in the following issue.

data is like this

date	Time spent
2020-12-10	1
2021-01-04	4
2021-03-18	2

Current behavior

I got December 2020 coming after April 2021

Expected behavior

To have December to be before January 2021 in the graph

Thanks in advance for your help

[amitchandak · Accepted solution]

@jbrolland , Try to sort again from three dots. I usually create a date table with month and month sort. I sort month on the month sort and use that. 

But in this case, Dec will come after April because it December.

On X-axis put both month year and try. Let the year be on column too

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[jbrolland]

Perfect it worked, I actually just needed to Sort by month from the three dots menu

Thanks a lot

[jbrolland]

I check this too fast, it actually not sorting properly

[jbrolland]

• I ended up concateneting Year and Month in a new colum as text

• Then sorting ascending by the new colum called Year and Month

Not super cleanas  I don't have the month name but did not find any better

[Syndicate_Admin]

I was served by your solution! Thanks a lot