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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |