Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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

v-lili6-msft
6 years ago
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

Icon for Super User rank

Super User

6 years ago

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

Related content