Posts tagged #Best Practices

Power BI Report-Scoped Measures: 6 Patterns for Better Reports

Video by: Reid Havens

Report-scoped measures (aka report-specific measures) are one of the easiest ways to level up a Power BI report without turning your semantic model into a junk drawer.

In this video, I walk through my Visual & Report-Scoped Measures guide and show the art of the possible. No deep DAX theory, no data engineering detours, just practical patterns you can steal immediately.

We’ll cover:

  • What “report-scoped” measures are (and when you should use them)

  • Six practical patterns for enhancing report UX with measures

  • Dynamic titles that respond to context

  • Conditional formatting driven by measures (so visuals explain themselves)

  • How to keep your model clean while still making reports more interactive and readable

If you build reports for humans (not just for your own amusement), this is a strong set of patterns to have in your toolkit.

Data Modeling vs DAX in Power BI: Solving Problems the Right Way (with Markus Ehrenmuller-Jensen)

LIVESTREAM DATE/TIME 📅

February 6th 2026 - 9:30AM (Pacific Time)

DESCRIPTION 📄

When should you solve a problem in the data model, and when should you solve it with DAX?

In this livestream, Markus Ehrenmuller-Jensen will walk through practical scenarios where you can take either route: modeling changes, DAX measures, or even report-level settings. Instead of “it depends,” you’ll see how to choose a clear, maintainable approach.

In this session, we discuss:

  • How a solid data model can simplify or eliminate complex DAX

  • When it actually makes sense to push logic into DAX instead of the model

  • Typical patterns: role-playing dimensions, cascading filters, synced slicers, and more - Trade-offs around performance, maintainability, and usability

  • How to think about long-term governance when mixing modeling and DAX solutions

Whether you’re a Power BI developer who loves writing measures or a data model purist, this session will help you decide where each piece of logic really belongs.

GUEST BIO 👤

​Markus Ehrenmuller-Jensen is the founder of Savory Data, with a career spanning project leadership, data engineering, and business intelligence architecture since 1994. He holds degrees in software engineering and business education and serves as a professor of databases and project engineering at HTL Leonding, a technical college. He is also certified in PL-300 (Power BI Data Analyst), DP-203 (Azure Data Engineer Associate Certification), DP-600 (Fabric Analytics Engineer Associate), and DP-700 (Fabric Data Engineer Associate).

Markus actively contributes to the global data community, speaking regularly at international conferences such as SQL Bits in London, Power BI Next Step in Copenhagen, Data Saturdays throughout Europe, and SQL Days. He co-founded SQL PASS Austria in 2013 and the Power Platform User Group Austria in 2016; both organizations merged in 2021 to form Data Community Austria. Since 2014, he has organized Data Community Austria Day in Vienna, fostering knowledge sharing among data professionals. In recognition of his technical leadership and community involvement, Markus has been honored as a Microsoft Data Platform Most Valuable Professional (MVP) since 2017.​

In addition to his speaking engagements, Markus contributes articles to reputable journals and has authored the book "Data Modeling with Microsoft Power BI," published in June 2024.

RELATED CONTENT 🔗

Markus's Website
Markus on LinkedIn
Markus on Bluesky
Data Modeling with Power BI (O’Reilly)
Selection2List DAX Package
Markus's GitHub

(Livestream Replay) Exploring Practical Front-End Techniques for Power BI Reporting - Gustaw Dudek

DESCRIPTION 📄

During the front-end development phase, we face many choices that will affect the usability, appearance, and overall experience of the report. To shed light on some of these issues, Gustaw will share his approach and thought process, conveying his experiences through selected use cases. Among the topics, there will be information on specific charts and nuances of their formatting, as well as Power BI functionalities like field parameters and conditional formatting, illustrated with concrete examples.

The subjects discussed during the live session are intended for all Power BI users regardless of their experience level—beginners, intermediate, and advanced. Some aspects may also appeal to users of other data visualization tools, given the universal nature of certain approaches.

GUEST BIO (Gustaw Dudek)👤

Gustaw Dudek is the Head Of Business Intelligence at the Polish Company - Enterium. He has multiple years of experience in the field of data analytics. He implements and provides business reporting solutions for various industries using Power BI tools. Gustaw is also IBCS® Certified Analyst, Enterprise DNA Platform Expert and Microsoft Power BI Community Representative. He developed extensive Power BI Portfolio, which includes diversified array of financial and operational reports as well as various demonstrative dashboards created in the frames of international BI challenges. He regularly shares his personal PowerBI-related experience through Linkedin Platform by showcasing diverse data visualization techniques.

RELATED CONTENT 🔗

Gustaw's LinkedIn
Gustaw's Power BI Content Repository Report
Gustaw'’s NovyPro Profile
Gustaw's Behance Profile

(Livestream Replay) Semantic Model Ideation for Power BI - Leslie Welch

DESCRIPTION 📄

Building a performant star schema semantic model for Power BI enables simpler DAX, improved load time and responsiveness, and ensures that you are able to use the visuals that will best communicate your data. When starting with a snowflake, disparate data sources, or one big table, it can be a challenge to build something from the start that is going to fit your user requirements.

Enter the semantic model ideation process. My team and I use this process to help clients create performant secure data models aligned to a star schema and Power BI best practices. Attendees will walk away with an understanding of what information they need to start this process, how to work through the steps, and how to validate the proposed model will support their visuals. We will work backwards from what data you need to support the user questions, what Power BI needs to support the visuals, and an overview of the approach to building out your medallion architecture technical requirements for Synapse or Databricks to enable Power BI semantic models.varius morbi.

GUEST BIO 👤

Leslie Welch is the Principal Fellow of AI & Analytics at Excella with over 16 years of experience in automation, data analysis and visualization, and strengthening organizations’ knowledge of data. Leslie has worked end to end in the data arena from capture and ETL to database design/engineering to analysis and dashboard design to ML use cases with a focus on improving productivity, performance, and data quality. She has extensive experience in enterprise deployment of Power BI, both as an admin and Power BI architect and a trainer and technical community organizer. She is passionate about data governance, truth telling in data, and responsible application of ML/AI. Leslie is co-organizer of Power BI DC, and frequently attends and speaks at data community meetups in the DC metro area. Leslie was recognized as a 2023 New Power Woman in Tech by DCA Live, and made the 2024 RealLIST Engineers for her role in helping the DMV tech ecosystem grow.

RELATED CONTENT 🔗

Leslie's LinkedIn
Meetup Group

Posted on October 18, 2024 and filed under Livestreams, Data Modeling.