Forum Discussion
Month on Chart x-axis Not Sorting Correctly
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")
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
1 Reply
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