List down columns and measures which are used somewhere in any visual or filter in power BI report

[anshul_marele]

Hi,

How to list down columns and measures which are used somewhere in any visual or filter in power BI report?

@PowerBI

[v-nuoc-msft]

Hi @anshul_marele 

Every visualization in Power BI has a Visual Level Filters section that by default includes all the columns and measures included in the visualization.

Applying a measure filter in Power BI - SQLBI

Add a filter to a report in Power BI - Power BI | Microsoft Learn

Here I have provided a simple example: 

Filtering values greater than fifty.

Here's some dummy data

"Table"

Create a mesure.

Measure = IF(SELECTEDVALUE('Table'[Values]) > 50 , 1, 0)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnalyticsWizard · Accepted solution]

@anshul_marele 

Consider this:

How to find and delete unused Measures in Power BI (youtube.com)

How To Automatically Delete Unused Columns And Measures In Power BI (youtube.com)

Solved: Find the unused Measure/Data - Microsoft Fabric Community

If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍