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.

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

Leave a Reply

%d bloggers like this: