Skip to main content
Microsoft Idea

Power BI

Needs Votes

List where a column or measure is used in a report

Vote (912) Share
Dave Gugg's profile image

Dave Gugg on 17 Dec 2016 06:00:28

It can be unwieldy to manage measures and columns, especially when custom measures and columns are built on top of other measures and columns. It would be helpful to have a [Where Used] option to provide a list of visuals and/or columns/measures where a particular column is used. That way you can delete unneeded measures/columns without worrying about breaking everything.

Comments (55)
Dave Gugg's profile image Profile Picture

Megan Thirtyacre on 05 Jul 2020 23:45:09

RE: List where a column or measure is used in a report

This is so relevant to a project I am working on, please consider it!

Dave Gugg's profile image Profile Picture

Paul Jose on 05 Jul 2020 23:43:19

RE: List where a column or measure is used in a report

Yes need that at the moment...

Dave Gugg's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:05

RE: List where a column or measure is used in a report

100% needed.

Dave Gugg's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:08

RE: List where a column or measure is used in a report

It would also be nice to have Search functionality within PowerBI, so you can search in all the Dax where measures/etc. are used, so you know all the places where you need to adjust something

Dave Gugg's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:14

RE: List where a column or measure is used in a report

Would make 'cleaning up the model' a whole lot easier..

Dave Gugg's profile image Profile Picture

Power BI User on 05 Jul 2020 23:34:11

RE: List where a column or measure is used in a report

The bigger a project grows, the more I wanted to have a list of all report where a field (column) is used. Also this function will be helpful when I need to review other project members' work.

Dave Gugg's profile image Profile Picture

Aparna on 05 Jul 2020 23:33:01

RE: List where a column or measure is used in a report

It looks like it has been 2 years since this suggestion was shared and there is still no resolution.
I would like to see this addressed ASAP as it is very useful and is very inconvenient to not have this feature

Dave Gugg's profile image Profile Picture

Kevin H on 05 Jul 2020 23:32:03

RE: List where a column or measure is used in a report

I agree, and to go a step further...

I would like to be able to do this in the Power BI Service, at the workspace level (or even the tenant level) -- to show a list of all reports where a field is used. For each occurrence of the field, what report is it in? What report page? Where on that report page -- which visualization...or, is it in a report- or page-level filter?

Because I have a workspace with over 100 reports, all based on one dataset, but created by many users. Say in the underlying dataset I remove a field, or change the name of the field. Now, I need to know all the places where the update needs to be made.

Dave Gugg's profile image Profile Picture

Avalon on 05 Jul 2020 23:30:28

RE: List where a column or measure is used in a report

Agree with this. Would be of major help.

Dave Gugg's profile image Profile Picture

Mike Donnellan on 05 Jul 2020 23:24:07

RE: List where a column or measure is used in a report

Agreed with everybody, at pre-publish cleanup time this would be a big help. Thanks.