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.
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?
If you are using live connection from Analysis Services.
you can do it in your analysis services model. click on the month name field and goto properties there you can see sort by column option click on the drop down and select month num column( if you don't have one already create one by using Calendar function). Process the cube and you can see changes in Power BI now.
Hope it helps.
Thanks
Pranay