Sorting by month number not working when trying to show months in correct order

[chillpill]

I am attempting to sort this chart by showing the months in the correct order and sorting the Month column by the Month Number method is not working. What am I missing here?

[grantsamborn · Accepted solution]

Hi @chillpill 

It looks like your visual is correct except for the sort order is reversed.  (The sort by MonthNo appears  to be working.)

At the top right corner of the visual, press "...", select "Sort axis" and choose "Sort Ascending".

Let me know if you have any questions.

[chillpill]

That did it, thank you!

[Padycosmos]

Hope this helps

[chillpill]

This is what I tried in my OP but it's not working so I must be doing something wrong. 

[galaamri]

Hi @chillpill 

Sort the column by Month Number. or Create a sepreate calendar table. 

First let's create a calendar table 

Calendar = CALENDAR(FIRSTDATE(table[date]),LASTDATE(table[date]))
then calculated column

Month= FORMAT('Calendar'[Date].[Date],"MMMM")

Year-Month-Code = FORMAT('Calendar'[Date],"YYYYMM")

Last step you would sort Month column by Year-Month-Code.

Please make sure calendar table and data table have a relationship