Date Axis - not ordering month label

[Anonymous]

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

[v-lili6-msft · Accepted solution]

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

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601