Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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")
Solved! Go to 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
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |