Sorting dates in query editor

[Anonymous]

Hi, 

I am having trouble sorting from newest-oldest for a date column in query editor. I know that I can sort it when I get out of the editor, but I want an applied step that sorts the dates. When I sort by descending, it puts the dates like this: 8/30/2019, 7/30/2020, 6/30/2016, 5/30/2020 (just an example). It sorts the dates based off of the first number rather than the actual date. 

Please let me know how I can solve this issue because I need it to be a step in the query because I need to add steps after that rely on the dates being sorted from newest to oldest.

[Vickchan]

I did Sort button in the center of the ribbon in query editor, but it was wrong sorting in Data view after refresh. how to fix it?

[amitchandak]

@Anonymous , Is this column is date or text column. Because in case it is date column desc sort should work properly.

On visual there are three dots .., you can go and change visual level sort.

In case it is a text column you can define a sort column and mark that as sort column.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[mahoneypat · Accepted solution]

On the home tab in the query editor, there is a Sort button in the center of the ribbon.  Just highlight the column to sort and then choose the sort order.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Thank you @mahoneypat . For some reason, if I use the drop down at the top of the column to sort the dates, it does it incorrectly. However, if I use the sort tab on the home page, it works how it should. Thank you!