22-25 April 2026

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:00

TL; 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.

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.

Speakers

Reid Havens

havensconsulting.net/blog-and-media