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

Re: Month Name in sorting order

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?

Highlighted
Frequent Visitor

Re: Month Name in sorting order

Perhaps you can try to reload the data table and try to restart Power BI.  I experience this too.

Highlighted
Anonymous
Not applicable

Re: Month Name in sorting order

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

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