Sorting of Month Year

[Anonymous]

I have a column called month year that runs from Jan 2010 - Dec 2020

When I create a slicer for it, it sorts as :

Apr 2010

Apr 2011  and so on if it is sorted by month and

Jan 2010

Jan 2011 and so on if sorted by year.

I Would like to know how to sort it as folllows:

Jan 2010

Feb 2010

Mar 2010

....

Dec 2010

Jan 2011

Feb 2011

....

Is there any way this can be done?

Thank You!

[jainbhavesh9]

thanks it works

[Anonymous]

You might also be able to change that month/year column into a date column and then it will sort automatically.  I did that and it still retained the month/year format (save before you try)

[Anonymous · Accepted solution]

@Anonymous 

one solution is calculate a new column (year *100 + month num) and sort your month year column by this new column

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

this way april 2010 and april 2011 would show as 201004 and 201104 respectively.

[Anonymous]

@Anonymous It Worked. Thank You!