How to sort month in order ?

[NPArulventhan]

Thanks advanced !!!

My month field show in alphabatic order , how can i sort in correct order . pls help me, its quick call

[Baskar · Accepted solution]

Cool...

Choose your Dimesion and then click the modelling ribbon there u can find the "Sort by Column" from that u can choose based on what measure u want to sort .

it will solve your prob if not let me know i will help u 😉

[Anonymous]

Hi Baskar

Please can you share the screen shots. I'm new to Power BI and I cannot find the Modelling Ribbon.

Appreciate if you can share the screen shots.

Thanks

Mahad

[BreeC]

Why is the sort option greyed out on my modeling ribbon?

[BreeC]

I got my report to sort:

Choose a field under the fields list and click on it so that it is highlighted. 

Navigate to the Modeling ribbon and click on the sort by column. 

You will see that the month field (this is what I selected) that was selected is now shown as the default. 

Select the field that you want to sort by (I have a field called MonthSort).  This field has the month number, but the month field displays the month in words.  After this field is selected, the report sorts.