Yes, yes we are. 😢

Debugging real world problems for our students is just 1 benefit of our AKA sessions! The #SelfServiceBI (skw-t.com/ssbi) and #Excel Fundamentals (skw-t.com/excelfun) Academies come with access, or purchase just the AKAs at skw-t.com/aka
Plus, save 25% with code 2025CYBER (expires Dec 5, 2025).

Because the page was oversized, scrolling inside visuals eventually turned into scrolling the entire oversized canvas… taking the slicers and headers with it. Switched back to a standard 16:9 canvas, everything snapped into place. No more runaway scrolling and headers stayed where they belonged. 😎

📕The #BusinessIntelligence Bundle includes:
▪️Master Your Data by @excelguru.ca and Miguel Escobar
▪️Power Query: Beyond the UI by Chandeep Chhabra
▪️Power Query Recipes by @excelguru.ca
▪️Supercharge Power BI & Excel by Matt Allington
▪️Power BI for the Excel Analyst by @wynhopkins.bsky.social

Don’t just watch the course lessons and hope you “get it.” Our #SelfServiceBI (skw-t.com/ssbi) and #Excel Fundamentals (skw-t.com/excelfun) Academies come with access to AKA sessions where we guide you through applying what you’ve learned.

#PowerBI #DataAnalytics #BusinessIntelligence

Ken's fix? Just delete the hardcoded column count argument in the formula bar and 💥boom, all columns load again! It was equal parts relief and frustration for everyone watching. 😅

🧭 Takeaway: Check for hidden hardcoded parameters - sometimes Power Query sets you up for failure!

Stuck trying to apply what you’ve learned to your own data? With our #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies, you don’t have to go it alone. Bring your questions to our instructor-led AKA sessions and get unstuck, fast.

It was one of those classic “Aha!” 💡 moments - turning a messy logic question into a clean model design with a simple DAX formula:
=CALCUALTE( [Sales $], Product[Commissionable] = "Yes" )

🧭 Takeaway: When in doubt, model it out. Adding a simple column can save hours of DAX headaches later!

We almost put a sad face emoji in the original reply, but then thought that might send mixed messages. 😜

Agreed, this is really stupid.