Text Order in Graph

[Colinu]

HI All

I have a data set that contains the month but in as Text. 

When i bring this in to the visual is orders it by alphabetically order.

Is there a way that you can force the visual to retain the order in the table.

Colin 

[v-yulgu-msft · Accepted solution]

Hi @Colinu,

Please refer to the methods mentioned in below links:

Custom Sorting in PowerBI?

Date Sorting chronologically

Best regards,

Yuliana Gu

[rajulshah]

Hello @Colinu,

You can create a column in your Dates table as follows:

YearMonthNumber = FORMAT(DTdates_data[Date],"yyyyMM")

And then create another column 

MonthYear = DTdates_data[Month]&" "&DTdates_data[Year]

And then select your MonthYear Column in the screenshot and then go to Modelling tab > Sort Column > YearMonthNumber.

You will get your months sorted in the visual.

If you can't get the results, please revert back.