Power BI is ordering columns Month 1 ... Month 60 Month 7 Month 8?

[CapnShanty]

I have unpivoted my 60 month columns that follow the format MONTH 1 ... MONTH 60, but when I try to put them on a line chart it puts months 7/8/9 after month 60... and other stuff like month 3 after month 29... 

How do I change this? 

[v-juanli-msft · Accepted solution]

Hi @CapnShanty

In query editor, create a column to extract the month number of ache month.

=Text.Range([Attribute],5)

Then convert the data type of  "month number" column to "number".

Select " close&&Apply", then in Report view, click on the "Attribute" column, then click on "Modeling"->"sort by column"->"month number", the line chart will show month from "month1" to "month 60" in the correct order.

Best Regards

Maggie

[Greg_Deckler]

Create a column that wipes out the "MONTH" text so that you are just left with the numbers. Use the "Sort By" feature to change the sort by column for your column to this new numeric column.