Microsoft BI Platform

Power BI Product Suggestion: Show Measure Dependencies

I was just working on a client project where we have several complex measures that reference other measures. Sometimes it can be hard to keep all these dependencies in mind. As a feature, it would be great for Power BI Desktop to show these dependencies and navigate between them. After a quick search in the Power BI Community Ideas site, I posted a suggestion. Afterward, I found an older suggestion made by Avi Signh here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

Here’s my version in the mockup below. I think there’s a lot of potential to pile-on and add to this idea but I think that having a simple tree view of dependent measures would be a great start. If you agree, please vote this idea up on the Power BI community forum.

Show measure dependencies in the field list

Measures that reference and depend on other measures can be difficult to trace and debug.  To make this easier, provide the option in the field list to show the measures that are referenced by other measures. This should be optional and performed individually for each measure to avoid unnecessary performance overhead.  Here’s a conceptual mockup:

measure dependency
Paul Turley

Paul Turley

Microsoft Data Platform MVP, Principal Consultant for 3Cloud Solutions Specializing in Business Intelligence, SQL Server solutions, Power BI, Analysis Services & Reporting Services.

Related Posts

Creating and Displaying a Last Refresh Date Measure

Business users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either “when was the last date & time that the source data was updated?” or “when was the last date & time that the data model was refreshed?”
I’ve used a few different approaches to record the actual date and time, but all generally using the same technique.

Power BI and the Dimensional Dilemma

There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality requires a dimensional model, aka “Star Schema”. This is a hard fact that every expert promotes, and self-taught data analysts either have learned or will learn through experience. So, if everyone agrees on this point, why do so many resist this advice?

Perspective is everything. I didn’t understand why getting to the star schema was so out of reach so often until I was able to see it from another perspective. There are a few common scenarios that draw source data into different directions than an ideal dimensional model.

DevOps & CI/CD for Power BI

DevOps isn’t difficult to implement for small and medium-scale projects, and simple things like managing version control in a code repository can save hours of lost time. Organization who are accustomed to managing large application development initiatives might expect to have a fully automated build and deployment process in concert with an Agile delivery process, managed with specialized tools like Jira, GitHub and Azure DevOps.

2 thoughts on “Power BI Product Suggestion: Show Measure Dependencies”

  1. Thanks for the in depth knowledge on power BI. As I understand this involves lot of programming with various language and codes involved. Recently I encountered a BI tool which works on zero coding and tubeless architecture. How would you differentiate yourself with the tool I am referring

    Reply

Leave a Reply

%d bloggers like this: