Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Date Sorting chronologically

I am using a date table for data which is stored on a monthly basis. I need to show this data on a quarter end basis but when I use my quarter column it is sorted alphabetically not chronologically. ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    You should inserte the date sort column in Query Editor mode, rather than in data view mode.

     

    Regards,

    Yuliana Gu

Abduvali's avatar
Abduvali
Skilled Sharer
8 years ago

Hi Anonymous,

 

 

If you created the QUARTER column using FORMAT function then try following:

  • Drag and Drop your DATE field into the under Values in your table chart and from date hierarchy keep Year and Quarter

That way you should be able to sort the way you want.

 

 

Regards

Abduvali