Year Month Ordering

[Sam7]

Hello,  

How do I put these in order?

I have created a dates table, created this month year column, now I want to show all date, have a continuous x axis and want the order to be correct.  I have read numerous blog posts but can't find the answer.  I have tried sort etc, but as the month year is text it is not recognised. I have tried to go to the data and use sort order by column, and changed this to numbers - but no luck. 

Please help. 

[Sam7]

Thanks!

[amitchandak · Accepted solution]

@Sam7 , You need sort column

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

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