cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshaya Member
Member

Sorting of Month Year

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
mnayar Established Member
Established Member

Re: Sorting of Month Year

@Akshaya 

 

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.

 

 

3 REPLIES 3
Highlighted
mnayar Established Member
Established Member

Re: Sorting of Month Year

@Akshaya 

 

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.

 

 

Akshaya Member
Member

Re: Sorting of Month Year

@mnayar It Worked. Thank You!

Kroneborge Regular Visitor
Regular Visitor

Re: Sorting of Month Year

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)