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 (58)
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.
RE: List where a column or measure is used in a report
Agree with this. Would be of major help.
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.
RE: List where a column or measure is used in a report
Definately a needed function
RE: List where a column or measure is used in a report
This would be a great help.
Trying to clean up in a report with a lot of visuals and a lot of tables/columns.
RE: List where a column or measure is used in a report
I have made a mess during learning phase, but ultimately i got to the report i wanted ... but now scratching my head to what to keep and what not to ...
https://community.powerbi.com/t5/Desktop/Way-to-find-out-if-Measures-and-Columns-are-being-used-on-ANY/m-p/441103#M203662
RE: List where a column or measure is used in a report
This would be very helpful!
RE: List where a column or measure is used in a report
I need this desperately! Especially that it is not possible to do version tracking of Power BI files.