Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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? 
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

do you mean the date hierarchy? amitchandak 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        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.