Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sort months into chronological order

This is the error message I keep getting as its the rolling column which I have in my visual which needs sorting I think, as every other column which has been sorted has not affected the order....
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    You can create a sorted table, then establish a one-to-many relationship between the sorted table and the main table, use the RELATED function to create a sorting column in the main table, and finally make the rolling column sort by the sort column.

    sample:

    result:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    I noticed that the value in your sort table is "Rest of the Year", but the mapped value in your main table is "Rest of the Dates", and the value is different causing this to not correctly identify the sort order.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

     

     

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

hello, 

 

1) first check the sorting column you using as reference its in number format

2) you can just sort the table by the same column month and will have the same effect, now if you want a more organize sort, sort by the entire date, if what you want its all the data of the table sorted on that particually fiel do it on the same column refence for sorting and there should be fine