cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Month Name in sorting order

Hi All,

 

I want Month Name to displayed like in ascending or descending order not like this

2017-03-31_15h41_05.png

 

 

 

 

 

 

Thanks,

Pratima

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual
Impactful Individual

Re: Month Name in sorting order

Go to the database tab, select month name column from your calendar table.  Select the modeling tab and then "Sort by Column" and select your month number column.  Month name should now appear in the correct order.

View solution in original post

12 REPLIES 12
Highlighted
Impactful Individual
Impactful Individual

Re: Month Name in sorting order

Go to the database tab, select month name column from your calendar table.  Select the modeling tab and then "Sort by Column" and select your month number column.  Month name should now appear in the correct order.

View solution in original post

Highlighted
Helper III
Helper III

Re: Month Name in sorting order

Thank you Tjd for the valuable answers.....

 

Now i am getting the expected result

 

 

Thanks,

Pratima

 

Highlighted
Frequent Visitor

Re: Month Name in sorting order

I am running Power BI Desktop version 2.51.4885.701 and do not have a Database tab.  I have Home, View, Modeling, and Help.  Do you mean the Modeling tab?  If not, is there a different way to sort in numerical month order, instead of alphabetical month order?

Highlighted
Impactful Individual
Impactful Individual

Re: Month Name in sorting order

Sorry, tab is probably the wrong term, view would be more appropriate.  Within PowerBI Desktop, you have 3 icons on the left.  The top one is the visualization view, next is the data/database view, and the third is the relationship view.  Click on the data/database view and then follow the above instructions.  

Highlighted
New Member

Re: Month Name in sorting order

I have the same problem but the way I get my data into Power BI is with a live connection to Microsoft Analysis server. So I don't have a database view. How do I do it?

Highlighted
Helper V
Helper V

Re: Month Name in sorting order

I have the same problem, i'm using a live connection to a Analysis Service. So i don't see the three tabs on the left.

Anyone got a solution for this?

Highlighted
Regular Visitor

Re: Month Name in sorting order

Awesome, thank you for that... I would have wasted a lot of time on this...

 

Dave

Highlighted
Helper V
Helper V

Re: Month Name in sorting order

I have the same case it doesn't !!!

Highlighted
Post Patron
Post Patron

Re: Month Name in sorting order

Thank you. Ervery time I forget this. So adding comment here so that I can refer in future. 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors