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)
RE: List where a column or measure is used in a report
Seeing where (in multiple places) a measure is being used would be very useful. But also being able to get an overview of all measures used, and what measures are being used at all in any reports. This helps alot when cleaning up or refactoring, which otherwise becomes extremely time-consuming since each measure could potentially be used SOMEWHERE and you have to go look for it manually...
RE: List where a column or measure is used in a report
Yes please, make it so.
RE: List where a column or measure is used in a report
Yes please!
RE: List where a column or measure is used in a report
PowerBI very slow , want to remove as much column data on initial queries
RE: List where a column or measure is used in a report
Yes please - Much required functionality to better manage content within Power BI solutions.
RE: List where a column or measure is used in a report
Please, yes! This functionality is really required, it is almost impossible to discern unused formula and as such they are left in the model which is very messy. Thanks.
RE: List where a column or measure is used in a report
Yes, this function like the trace dependencies in Excel would be very helpfull.
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.