Unable to sort by month when using scatter chart

[Anonymous]

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? 

[Icey]

Hi @Anonymous ,

Please let me know if the method I provided in my last reply is helpful.😉

Best Regards,

Icey

[Icey · Accepted solution]

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]

@Anonymous , Make sure the sort column is defined. and you have sorted on month using three dots.

refer : https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

@amitchandak yes, i did this too 

This right?

[amitchandak]

@Anonymous , check the selected column, it should be the month name. I see some different column name on column tool

[Anonymous]

do you mean the date hierarchy? @amitchandak 

[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")

[Anonymous]

@amitchandak can you please have a look at this? https://1drv.ms/u/s!AoKh3nlpMpSOgmSAg1TMiavknFhn?e=NDMg6m

[amitchandak]

@Anonymous , I create a date table with month name and month in that table, joined it with your table and done changes in viusal. but it has not changed the sort order. still checking.

[Anonymous]

@amitchandak really appreciate if you could help me with this. thank you in advance! 🤗