Uploaded January 2024 | Updated September 2026, 2 weeks ago
Alretnative use case for slicers and how to format them.
⚠️as per a comment (from Excel off the grid) the Custom Sort Order only applies to your Excel session, it wint sort correctly for others ! ⚠️ Thanks Mark Proctor!
00:00 Intro
00:34 Setting up the Slicer Table
02:59 Magical Slicer Formatting
05:26 Forcing the Sort Order
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Alretnative use case for slicers and how to format them.
⚠️as per a comment (from Excel off the grid) the Custom Sort Order only applies to your Excel session, it wint sort correctly for others ! ⚠️ Thanks Mark Proctor!
00:00 Intro
00:34 Setting up the Slicer Table
02:59 Magical Slicer Formatting
05:26 Forcing the Sort Order
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/





![Practical use case for Power Query metadata
How to extract the number of records at each filter step in a query.
Thanks to these 2 resources:
🧑🏻💻Chandeep:
https://youtu.be/weafpG2yG1w?si=oM2s_VaIElTD-7Cu&t=361
🧑🏻💻Abhay Gadiya
https://youtu.be/JkNYvFoJ6HQ?si=tBoxdtc9xHVz955e
🔢Code:
Code also inside the Excel file
let
//MyQuerySteps = [
Your Code
//] in MyQuerySteps[YourLastStep] meta [MetaReference = MyQuerySteps]
in YourLastStep
📂Copy of File
https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiabCrVyIUVMqLfN9OldAroBDa6bzdvzqXjaeRgJ1zlChw?e=9m7dqM
Access Analytic
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/ Practical use case for Power Query metadata](https://i.ytimg.com/vi/IgQ-u9R3j8U/mqdefault.jpg)




