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
Looking forward to it, still, it is 2019 now...
RE: List where a column or measure is used in a report
I have been asked to optimize a report that was created by someone who has moved on from this team. Something like this would be an enormous help in figuring out which columns I can safely remove. Without it, the work is very manual and extremely time-consuming.
RE: List where a column or measure is used in a report
Sure would be helpful. Or, at minimum, some icon or highlighting on columns and measures to indicate they're used elsewhere - either in other measures/columns or in visuals. When you select a visual, it shows what columns/measures are used. I really hoped I could just 'select all' and see all columns in use. But it just deselects everything in that column view when you select more than one visual.
I have very low hopes of this being addressed, given how old this idea is.
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!
RE: List where a column or measure is used in a report
Yes need that at the moment...
RE: List where a column or measure is used in a report
100% needed.
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
RE: List where a column or measure is used in a report
Would make 'cleaning up the model' a whole lot easier..
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.
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