Havens Consulting
Video by: Reid Havens
Power BI insists on showing raw SVG or URL text when you hover over icons in tables, which makes everything look like a crime scene. This quick technique uses a tiny, blank report-page tooltip to override Power BI’s default behavior, effectively “disabling” tooltips for SVGs and URLs without breaking interactivity. It’s fast, reliable, and doesn’t require DAX sorcery or custom visuals.
Video by: Reid Havens
Microsoft's new calendar-based time intelligence isn't magic, but it's a necessary optimization for every new model (and existing ones with performance issues).
The Results:
✅ Simplified query plans
✅ Fewer rows scanned by Storage Engine (SE)
✅ Same DAX, better syntax
The performance gains come from smarter query optimization. If you're working with large fact tables and time-based calculations, this is how the engine should be working.
What I cover:
How calendar-based functions optimize the storage engine
DAX Studio query plan comparison (side-by-side)
Setting up calendar categories in Power BI
Migrating from classic DATEADD to calendar-based syntax
FREE Power BI Calendar Template (PBIX)
Calendar Template
Livestream - PBI Calendar Overhaul: Calendar-Based Time Intelligence (with Jeroen [Jay] ter Heerdt)
Calendar-based time intelligence
Microsoft Blog Announcement
Introducing calendar-based time intelligence in DAX
What started as a small idea among data geeks became one of Europe’s most celebrated data conferences. In this episode, I chat with Simon Sabin, founder of SQLBits, about how the event grew from its humble beginnings into a cornerstone of the Microsoft data community.
We explore what makes SQLBits unique—from its deep commitment to inclusivity and diversity, to its legendary themed parties and creative venues that make learning feel like an adventure. Whether you’ve attended before or are considering joining next year, this conversation pulls back the curtain on what makes SQLBits unlike any other tech event.
🎉 Expect stories, laughs, and maybe a bit of costume talk.
Simon runs a Data Consultancy Sabin.io enabling companies to make the most of the data they have by implementing a Dev Ops strategy.
He is passionate about the importance of the community and learning. He founded and continues to run SQLBits, the largest SQL Server Conference outside of North America, has been awarded as a Microsoft MVP since 2005 and was recently made a Microsoft Regional Director.
He has worked with data for all his career and worked with companies across all industry sectors including online retail, insurance, finance, motor sport.
October 31st @ 9:30 AM (Pacific Time)
Product Manager Jeroen ter Heerdt demos Power BI’s new calendar-based time intelligence (Preview) — the long-overdue toolbox for anyone who’s ever cursed at week calculations, fiscal oddities, or retail 4-4-5 madness. He’ll show how to enable the preview and use the Calendar options UI or the TMDL model view to declare calendars so DAX finally behaves the way your business calendar actually does.
Expect live demos of week-aware DAX, examples mapping fiscal/retail/ISO calendars, tips on validating calendars (cardinality, partial vs complete categories), and notes on when this can improve performance versus classic time intelligence. This session is practical, so follow along with the preview enabled and bring your weird calendar.
Dutch Data Dude. Product Manager at Microsoft.
Jeroen (Jay) ter Heerdt is a Product Manager at Microsoft. He works on Power BI and is passionate about "all things data"; his current focus is on DAX and modeling topics. He strives to be a “datanerd” in all aspects of his life. Jeroen combines enthusiasm, vision, and hands-on experience into his talks. He is on most social media as @jaypowerbi.
Calendar-based time intelligence
Introducing calendar-based time intelligence in DAX
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
