Date Sorting chronologically

[Anonymous]

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. I have inserted a date sort column to try and get around this issue but I get the following error message. Could some one help me with this issue?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

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

Regards,

Yuliana Gu

[Hasan]

Hi There,

when I had the similar problem, i used this link:

http://www.databear.com/power-bi-tips-sort-by-month-name/

Hasan

[Abduvali]

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