Scoped for Success: Why Composite Models are a Report's Best Friend
Regular 50 minute session for SQLBits 2026Thursday - 01 Jan 1970 - 01:00 - 01:00TL; DR
A showcase of how report-scoped objects like measures, calc groups, field parameters, custom calendars, and visual calcs boost flexibility and insight, and how composite models let you add this logic without polluting the core semantic model.
Session Details
Creating "report scoped" objects in Power BI can significantly enhance the interactivity and functionality of your reports, even when they introduce some added complexity by creating composite models. In this session, we will explore the practical benefits and use cases for adding elements like measures, visual calcs, calculation groups, field parameters, custom calendars, or disconnected slicers directly into your report PBIX. These enhancements allow for a more tailored reporting experience, increase the diversity of your visualizations, and improve the depth of insights. The trade-off of added model complexity is often outweighed by the flexibility and user-focused capabilities they provide.
Key highlights include:
• Leveraging field parameters for dynamic visualizations.
• Streamlining measures and calculations with calculation groups.
• Employing visual-level calculations to create unique “native visuals”.
• Using custom calendar tables for advanced time intelligence.
• Narrating visuals through measure-driven formatting.
This session will feature a series of demos showcasing scenarios where these "report scoped" objects deliver value worth the complexity, emphasizing their integration within composite models to enhance both the report page and the overall user experience.
Key highlights include:
• Leveraging field parameters for dynamic visualizations.
• Streamlining measures and calculations with calculation groups.
• Employing visual-level calculations to create unique “native visuals”.
• Using custom calendar tables for advanced time intelligence.
• Narrating visuals through measure-driven formatting.
This session will feature a series of demos showcasing scenarios where these "report scoped" objects deliver value worth the complexity, emphasizing their integration within composite models to enhance both the report page and the overall user experience.
3 things you'll get out of this session
Learn to enhance interactivity with report-scoped objects.
Understand how to balance complexity in composite models.
Master advanced techniques like custom calendars and visual calcs.
Understand how to balance complexity in composite models.
Master advanced techniques like custom calendars and visual calcs.
Speakers
Reid Havens's other proposed sessions for 2026
Becoming a Master Builder: Creating the Ultimate BI Developer Toolbox - 2026
Building a Data Platform that Delivers ROI, Value, and AI Readiness - 2026
Design a Well-Architected Fabric Solution: A Medallion First Approach - 2026
F is for Fabric - 2026
Fabric for Muppets - 2026
Lights, Camera, Data!: Building Your Brand through YouTube and Speaking - 2026
Navigating Microsoft Fabric: A Practical Guide to Tool Selection - 2026
Power BI Feature Overload: Balancing Flexibility with Maintainability - 2026
Power BI Features I Regret Using (So You Don’t Have To) - 2026
Power BI Settings That Are Secretly Ruining Your Reports - 2026
Semantic Models Comes First: Managing Models for Growth and Self-Service - 2026
Speaker Hacks for Nervous Nerds (From a Nerd Who Talks a Lot) - 2026
Upgrading Power BI Architecture - 2026
Reid Havens's previous sessions
Thriving with ADHD in Tech: Unleashing the Data Analyst Superpowers Within
Learn how to leverage ADHD as a distinct advantage in the tech domain, specifically as a data analyst. This session dives deep into the inherent strengths of ADHD individuals, offering actionable strategies to amplify productivity and navigate challenges. Topics include optimizing the ADHD attributes of creativity and hyperfocus for data tasks, crafting an ADHD-conducive workspace, mastering time management, enhancing team communication, and emphasizing mindfulness for career longevity. By the conclusion, attendees will have a comprehensive toolkit to harness their unique ADHD attributes and flourish in the tech landscape.
Supercharge Power BI Tooltips
Discover secrets of tooltip design in Power BI. Learn how to upgrade your tooltips with DAX, add dynamic charts to report page tooltips, and add design elements to information/help tooltips.
Beyond Buttons: More Than Meets The Eye
In this presentation you'll see many unique and creative ways to implement both both bookmarks and buttons to supercharge the filter and navigation experience for your users.
Steve Campbell
Steve Campbell's other proposed sessions for 2026
Becoming a Master Builder: Creating the Ultimate BI Developer Toolbox - 2026
Building a Data Platform that Delivers ROI, Value, and AI Readiness - 2026
Design a Well-Architected Fabric Solution: A Medallion First Approach - 2026
Navigating Microsoft Fabric: A Practical Guide to Tool Selection - 2026
Semantic Models Comes First: Managing Models for Growth and Self-Service - 2026
Upgrading Power BI Architecture - 2026