Forum Discussion
MeenalPatel
Microsoft Employee
3 years agoDates are all messed up
How to sort dates in Chronological order? Sorting my month (asc/des) does not help.
3 Replies
- FreemanZ
Super User
hi MeenalPatel
try to
plot the x-axis with a new calculated column
YYYYMM = FORMAT([Date], "YYYMM")
or try to plot with month number column
Month = MONTH([Date])
or add the Month column
in the tooltips of the visual and sort by Month column. this works for some visuals.
- Ashish_Mathur
Super User
Hi,
First of all, the months on the X-axis should be dragged from the Calendar Table. In the Calendar Table, there should be columns of Month name and Month number. Use the "Sort by column" feature to sort the Month name by Month number.
Hope this helps.
- MeenalPatel
Microsoft Employee
Thanks Ashish, I was able to sort it by column.