Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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?
@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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |