Forum Discussion
Date Axis - not ordering month label
Hi, please see the attached image. I can't figure out how to get the months in order in the chart - does anyone know the best way to achieve this?
Appreciate any help
Thanks
hi Anonymous
Just add a Month No column, then selected Month name column and choose sort by column ->Month No
Result:
here is blog for you refer to:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Regards,
Lin
2 Replies
- amitchandak
Super User
In your table, you need to have a sort column like
month year sort = format(date,"YYYYMM")
And you have to mark it as sort column in the data view.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 
v-lili6-msftCommunity Support
hi Anonymous
Just add a Month No column, then selected Month name column and choose sort by column ->Month No
Result:
here is blog for you refer to:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Regards,
Lin
