How to See Which Fields Are Used in Power BI

Inheriting a Power BI report can feel like being handed the keys to a spaceship with half the labels scratched off. You have a complex model filled with dozens of tables and hundreds of fields, but no idea which ones are actually powering the visuals you see. This article will show you several ways to figure out exactly which fields are being used in your Power BI dashboards, from simple visual checks to more powerful, automated methods.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Checking Which Fields Are Used?

Taking the time to identify used and unused fields in your Power BI file isn't just about satisfying your curiosity. It’s a critical maintenance task with real benefits, helping you to:

• Clean up cluttered reports: Old projects can accumulate a lot of "data debt" - fields and measures that were created for a one-off analysis and are no longer needed. Removing them makes the data model easier for you and your team to navigate.
• Improve performance: Every column, especially those with high cardinality (many unique values), consumes memory and processing power. Removing unnecessary fields can make your report run faster, feel more responsive, and refresh more quickly.
• Safely modify your data model: Before you delete or change a column, you need to know if it will break an existing visual or measure. Verifying its usage prevents you from accidentally showing an error on a key dashboard right before a big meeting.
• Understand a new model: When you take over a report someone else built, understanding column dependencies is the fastest way to learn how the report is structured and where the key logic resides.

Let's walk through four effective methods, starting with the simplest and moving to the most powerful.

Method 1: The Quick Visual-by-Visual Check

This is the most direct and intuitive method, perfect for investigating a specific chart or a simple, single-page report. It doesn’t require any special tools - just clicking around the Power BI canvas.

The idea is simple: when you select a visual, the Data pane on the right side of the screen automatically highlights the fields that visual is using.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Open your report in Power BI Desktop.
2. Go to the page containing the visuals you want to check.
3. Click on any visual on the canvas, like a bar chart, table, or card.
4. Look over at the Data pane. Power BI will put a checkbox next to every field from your tables that is being used in the selected visual.

For example, if you click on a "Sales by Region" bar chart, you’ll likely see checkmarks next to 'Sales Amount' from your Sales table and 'RegionName' from your Regions table. This instantly tells you what data is feeding that specific chart.

Best for: Quickly understanding a single visual or a report with only a handful of charts.

Drawbacks: This process is entirely manual. If your report has many pages and hundreds of visuals, clicking through each one to catalog the fields would be incredibly time-consuming.

Method 2: Use the Performance Analyzer for a Page-Level View

If you need to analyze an entire report page at once, the Performance Analyzer is your best friend. While its primary purpose is to help you find and fix slow visuals, it has a fantastic side effect: it shows you the DAX query for every visual, which explicitly lists all the fields being used.

Step-by-Step Instructions:

1. In Power BI Desktop, go to the View tab in the top ribbon.
2. Click on the Performance Analyzer button. A new pane will open on the right.
3. In the Performance Analyzer pane, click the Start recording button.
4. Next, click Refresh visuals. Power BI will reload all the visuals on the current page and log the performance data for each one.
5. You will now see a list of every element on your page, along with the time it took to render. Click the small dropdown arrow next to any visual's name to expand its details.
6. Look for the DAX query section and click Copy query.
7. Paste this query into a text editor like VS Code or Notepad. The query will look complex, but you can easily read through it and pick out the table and field names, which are typically written in the format 'TableName'[FieldName].

To make this process even easier, you can click the Export button at the top of the Performance Analyzer pane. This saves all the data from your recording session - including every DAX query for every visual on the page - into a single JSON file. You can then open this file and use a simple text search (Ctrl + F) to see how many times a specific field is mentioned.

Best for: Getting a complete list of all fields used on a single report page without clicking on each visual individually.

Drawbacks: This method is still page-by-page, and you’ll need to do some text sleuthing to extract all the field names from the DAX queries.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Uncover Unused Fields Across the Entire Report with External Tools

For large, mature reports, your goal is often the inverse: finding what's not being used so you can safely delete it. The most efficient way to do this for your entire BI file is with free, community-built external tools that plug directly into Power BI Desktop.

One of the best tools for this job is Tabular Editor.

You can enable external tools by simply installing them. Once installed, they'll appear in the External Tools tab in Power BI Desktop. Tabular Editor allows you to directly view and manage your data model’s structure.

How to Find Unused Columns with Tabular Editor:

1. Install Tabular Editor 2 (the free version). It will then appear in the External Tools ribbon in Power BI Desktop.
2. With your report open, click the Tabular Editor button from the ribbon to launch it. It will automatically connect to your data model.
3. In Tabular Editor, go to the Tools menu and click Best Practice Analyzer (or press F10).
4. The Best Practice Analyzer checks your model against a set of performance and maintenance rules. The built-in rules already include one for locating unused columns!
5. Make sure the Unused columns rule is checked under the Performance category. Click Analyze All.
6. Tabular Editor will scan your entire model - every visual, measure, calculated column, and relationship - and produce a list of all columns that are not referenced anywhere.

The output gives you a definitive "safe to delete" list. You now have the information you need to go back into Power BI and start cleaning up your model with confidence, knowing you won’t break anything important.

Best for: A full report audit, identifying all unused columns for cleanup, and implementing best practices.

Drawbacks: Requires a one-time setup of installing an external tool. It might feel a bit intimidating for absolute beginners, but it's a huge time-saver once you try it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Best Practices for a Clean & Lean Power BI Report

Finding out which fields are used is a reactive process. A more proactive approach is to build your reports cleanly from the start. Here are a few tips:

• Hide Unnecessary Fields: In Power BI's Model view, right-click any column that isn't meant for direct use in visuals and select "Hide." This is common for columns used only as part of a measure, for sorting another column, or for establishing relationships. They still work in the background but won't clutter the Data pane for end-users.
• Create a "Measures Table": Keep your custom DAX calculations organized. Create a blank table (using the "Enter Data" option) and name it something like "Key Measures." Then, move all your measures into this table. This separates your logic from your raw data tables and makes them much easier to find and manage.
• Trim Bloat at the Source: The best place to remove unused columns is in the Power Query Editor, before they are ever loaded into your data model. If you know you'll never need the 'last_updated_timestamp' or 'user_comment' fields from a source table, remove them during the data import process.

Final Thoughts

Understanding what's happening under the hood of your Power BI report is the difference between being a user and being a developer. Whether you’re clicking through visuals one by one, using the Performance Analyzer to inspect a page, or running Tabular Editor to clean up your whole model, you now have the tools to analyze and optimize your reports effectively.

Of course, this kind of report forensics is often a symptom of having to work with rigid, complex dashboarding tools. Instead of digging through DAX queries to understand a report, we built Graphed to simplify the whole process. You can connect your data sources in a few clicks and then just ask questions in plain English, like "Show me my sales by region as a bar chart for last quarter." Graphed builds the live, interactive dashboard for you in seconds, so you can focus on insights instead of getting stuck on manual cleanup.