List of used fields in visuals (and in calculated fields and measures)
How can I get a documentation which mentions which field is used on a visual? or in a calculation of a column or measure?
With DAX studio we can make a list of calculated fields and measures. And with a little programming we can see which field as source for another calculated field or measure.
I know that by clicking on a visual the involved dataset will be highlighted into yellow. If I expand it, I see data fields used (which is selected) in this visual.To do this manually I'll need to click on each visual, manually make a note of every field used, cliick on the next visual, manually make a note of fields used...>> iterate. That'll take ages.
Main purpose is to eliminate all unneccessary fields and ... documentation!
I had the problem a few times and created a simple web site to analyze a PBIX file and find unused fields
Just as a side thought on this; we use an analytics cube so by it's nature we can have custom measures but not custom columns when working in live. You can have calculated columns by building a query that just custom selects the fields you want, but realistically you're building visuals up on the fly and don't know at the outset what fields you might need. Being able to have a either highlighting or an embedded tool to tell you which fields are being used on which pages and which visuals would make it quicker to make a decision what you pull through to your custom query when you get to the stage of wanting to manipulate the dataset with custom columns.
Daniel Davis commented
This would be a nice built in feature, for sure. There is another idea about a complete Measure management interface. I'd love. love to see that.
In the interim.. for anyone needing this DAX Studio can do this if you spit it out to excel.
If you launch DAX studio and run the following MDX query:
SELECT OBJECT_TYPE, [TABLE], OBJECT, EXPRESSION, REFERENCED_TABLE, REFERENCED_OBJECT
WHERE OBJECT_TYPE = 'MEASURE' OR OBJECT_TYPE = 'CALC_COLUMN'
ORDER BY [OBJECT] ASC
This will give you all Measures and calculations as well as their dependent columns
Mary Garcia Charumilind commented
This would be very handy. Some of our files are enormous, and can be drastically reduced in size by removing unused columns. This is currently very time consuming.
Shaun wilkinson commented
Would love a right click "Where used List" showing any other measures or a list of the Visual names that the field/measure is used in
Anthony MInero commented
agree, this is a very manual process as it stands right now. This would also help with new hires that need to be trained on reporting. Would give a good documentation of how the report is built.
Fortunately Reza Rad also thought this would be very useful. Check out http://radacad.com/power-bi-helper
SunilDutt N commented
This is a very grand feature to be available in Power BI service/desktop. It helps to identify the unused attributes and leverages the Power BI model simplification.
Ian Maddrell commented
I think this would be a great idea
Sasha Marsee Holder commented
Yes!!!! Similar to Trace Precedents in Excel.
This would be very useful to keep file sizes down be excluding unneeded columns from queries
+ ability to search for reused measures/calculated columns/fields to find where they have been used. This will be especially useful when you change a measure and want to see what effects it has taken on other measures. Same for fields and cal. columns.
Dynamic management views (DMV) for Power BI workbooks. This could allow us to quickly find every location where a column was used as a filter and update the filter values. The only way to do this now is by manually checking every chart object on every tab in every workbook. If I have an average of 8 visuals per tab, 6 tabs per workbook, and 10 workbooks, that's 8 * 6 * 10 = 480 chart objects to check manually. :(
Please do this. I am given a PowerBI workbook with half a dozen pages and a dozen tables. I need to replicate the underlying data. Knowing which visuals use which tables will go a long way toward helping me understand how to build the underlying tables.
yes! Please look into this request! i have many reports with so many visuals on so many pages, i wanted to do housekeeping to eliminate unused measures or fields, its going to take me ages to do that! or is there any work around solution for this??