Skip to main content
Microsoft Idea

Power BI

New

Add a simple flag to the fields panel to identify fields and measures used anywhere in the report

Vote (99) Share
Wyn Hopkins's profile image

Wyn Hopkins on 2022-03-04 09:05:48

Would be really helpful if we had a simple flag to identify if a field or measure is used anywhere in the report


Image as per this tweet: https://twitter.com/wynhopkins/status/1499636190320132097?s=20&t=Z-Gis9AGB6e9WnT9KU4vpg


Ideally we'd have all the bells and whistles to identify exactly where they are used like Imke Feldmann's Cleaner Tool https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/ but I'd be happy with a simple tick just to get started.


There are quite a few related ideas to this - maybe we can consolidate them all


Comments (9) Merged Idea (6)
Vote 8
Inacio Baldovino's profile image

Inacio Baldovino on 2020-11-03 12:01:30

Power BI

know what fields are in use

As you might know sometimes we end up importing several tables or data fields from tables that we end up not using, which make the report slower. I believe that knowing with columns or measures are being used either on a visual or in a custom column/measure could help clean up reports after we f...

Merged
Vote 3
Steffen Dyrholm Bundgaard's profile image

Steffen Dyrholm Bundgaard on 2021-10-18 08:50:21

Power BI

qucik analysis of measures to identify which are inactive

Hi, could it be possible to add a quick analysis button for PowerBI to do analysis on all measures in the rapport and identify those who might be inactive, meaning that the measure aren't used in any visuals and isn't connected to any other measures which are used in a visual or a table etc... It...

Merged
Vote 9
Vivek Sasidharan's profile image

Vivek Sasidharan on 2018-12-05 01:11:59

Power BI

An option to list all the used/unused fields in a report

There should be an option which lists all the used or unused fields in that report so that it will be easier for the end user to optimize the performance of the report and save time as well.

Merged
Vote 3
Dipak Bhudia's profile image

Dipak Bhudia on 2020-06-24 23:32:41

Power BI

List Fields used in reports in Usage Metrics Report for data lineage / stewardship

It is often important to inform the business when a field in a dataset will be modified or removed. Instead of sending out a blanket email to all users that a field will be impacted. It will be better to identify all reports that will be impacted and then reach out to the creators of those repor...

Merged
Vote 12
Janet's profile image

Janet on 2017-09-02 02:43:40

Power BI

Quick view to identify "used" measures

Identify measures that are on the dashboard/report and those measure that are precedents/dependents to those on the dashboard, Basically house keeping needs.

Merged
Vote 11
's profile image

on 2018-12-18 07:01:26

Power BI

Identify orphan measures and redundant columns

A way to easily identify redundant columns and orphan measures that are not in use in the model and probably were created during development.

Merged