Forum Discussion
Unable to sort by month when using scatter chart
Hi. I dont understand why cant I sort by month. Im using scatter chart. and I have already created new column to be sorted by x-axis. Is scatter chart cant be sort?
Hi Anonymous ,
Have you tried this?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
amitchandak
Super User
Super UserAnonymous , Make sure the sort column is defined. and you have sorted on month using three dots.
- amitchandak
Anonymous , check the selected column, it should be the month name. I see some different column name on column tool
- amitchandak
Anonymous , you can create month column and sort that on month no
Month = FORMAT([Date],"mmmm")
Month Year sort = month([Date])Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")