Forum Discussion
Sorting dates in query editor
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. Wh...
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 , 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