Uploaded February 2026 | Updated September 2026, 2 weeks ago
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
After 10 years of using Power Query, there are still new tricks to discover—and this one is surprisingly simple but incredibly useful. In this video, you’ll learn how to sort columns alphabetically in Power Query using both the classic desktop method and the newer modern interface. Whether you're building custom columns or just want a cleaner, more organised query layout, this quick tip can save you time and frustration.
But that’s not all. You’ll also discover why the traditional “Choose Columns → Sort by Name” trick doesn’t work in Dataflows or Excel Online—and what to do instead using Schema View. Plus, for those who want a fully dynamic solution, the video walks through how to use M code (including Table.ColumnNames and List.Sort) to automatically sort columns every time your data refreshes. Simple hack, modern workaround, and advanced dynamic method—all in one practical tutorial.
📊Do you want to learn Power BI?
Check out our amazing course at accessanalytic.thinkific.com
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
After 10 years of using Power Query, there are still new tricks to discover—and this one is surprisingly simple but incredibly useful. In this video, you’ll learn how to sort columns alphabetically in Power Query using both the classic desktop method and the newer modern interface. Whether you're building custom columns or just want a cleaner, more organised query layout, this quick tip can save you time and frustration.
But that’s not all. You’ll also discover why the traditional “Choose Columns → Sort by Name” trick doesn’t work in Dataflows or Excel Online—and what to do instead using Schema View. Plus, for those who want a fully dynamic solution, the video walks through how to use M code (including Table.ColumnNames and List.Sort) to automatically sort columns every time your data refreshes. Simple hack, modern workaround, and advanced dynamic method—all in one practical tutorial.
📊Do you want to learn Power BI?
Check out our amazing course at accessanalytic.thinkific.com
📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/
The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
