Month on Chart x-axis Not Sorting Correctly

[a_fman]

Using the following formatting code for the dates and they never seem to be able to be sorted correctly on the visual when sorting by MonthYear a-z. Why is this? It's quite frustrating.

MonthYear = FORMAT( DimDate[CalendarDate] , "MMM yyyy")

[v-qiuyu-msft · Accepted solution]

Hi @a_fman,

This is due to the MonthYear column is TEXT data type, if we set the chart sort by MonthYear column, the X axis values will display based on the first character of the each value. 

To make the X axis sort based on calendar date order, you can change the Format of DimDate[CalendarDate] column as MMMM yyyy, set the X axis type as Categorical. Then set the chart sort by DimDate[CalendarDate] column. 

Best Regards,
Qiuyun Yu