Skip to main content

Power BI

Needs Votes

List where a column or measure is used in a report

Vote (376) 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 (35)
Dave Gugg's profile image Profile Picture

0278353e f6c3-475e-8481-3500ca9f11b3 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

67c312f9 8645-45b1-8cd1-31f8cd5dd877 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

6a0e3ab5 196f-4a9d-8f8c-b35c3d0da41b 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

f3b3dd18 f316-475e-87db-327b4692385b 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

2a686a12 6b1e-4a8a-8b29-49bce575fe6b 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

8c5adaf8 082f-4406-803c-f06329d33ed4 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

1d55aca6 dfc9-4a24-903d-01997076c4e8 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

3101328d e4e2-4d82-a3ff-9aefdd878e1e 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

03397672 d8bb-40f1-acfd-dea914580feb 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

3d5d022f 540c-46e5-8827-da4d6b65fcdd 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.