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
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        amitchandak really appreciate if you could help me with this. thank you in advance! ðŸ¤—