Forum Discussion
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.
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.
Thank you Tjd for the valuable answers.....
Now i am getting the expected result
Thanks,
Pratima
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?
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.
Awesome, thank you for that... I would have wasted a lot of time on this...
Dave
I have the same case it doesn't !!!
Thank you. Ervery time I forget this. So adding comment here so that I can refer in future.
My sort by column is greyed out. And I do not have a live connection either. How do I get my table to show month columns in the right order?
Perhaps you can try to reload the data table and try to restart Power BI. I experience this too.
- Other than it should say Go to the Data View tab, works like a charm. Thanks
- Other than it should say Go to the Data View tab, works like a charm. Thanks
For me, I don'st have Database Tab so I clicked on the sheet in Data and then Sort By Column in Column Tools. Thanks, this was very helpful!
