Uploaded June 2025 | Updated September 2026, 2 weeks ago

---

The think about old tricks that everyone knows is that lots of people don't know them yet!

This tutorial not only walks you through building out source data using XLOOKUP and conditional formatting alerts but also shows how to set default layouts, eliminate annoying nesting, and harness the magic of "Show Report Filter Pages."

🧑🏻‍🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com

📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

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/

🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join