How to Filter Columns in Power BI

One of the first and most important steps in building a Power BI report is cleaning up your data, and that almost always starts with getting rid of columns you don’t need. Keeping your dataset lean and focused is critical for both performance and usability. This guide will walk you through simple and effective ways to filter columns in Power BI so you can build cleaner, faster, and more intuitive reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Should You Filter Columns in the First Place?

It's easy to get excited and pull every possible piece of data into Power BI, but this habit can cause problems. Taking a moment to remove unnecessary columns is a non-negotiable best practice for a few key reasons:

• Improved Report Performance: The more data your report has to load, process, and store, the slower it will be. Each column adds to the size of your data model. Removing ten unused columns from a dataset with a million rows can significantly reduce memory usage and speed up your visuals.
• Reduced Clutter and Easier Navigation: When you start building visuals, you’ll be working from the "Fields" pane on the right-hand side. A list of 50 columns is much harder to navigate than a curated list of 15. A clean Fields pane makes it faster to find what you need and easier for colleagues to understand your work.
• Sharper Focus on What Matters: Removing irrelevant columns forces you to think about what data is actually necessary to answer the business questions at hand. This analytical discipline helps you build more focused and impactful dashboards.
• Simplified DAX and Modeling: When you start creating relationships between tables and writing DAX measures, a simpler data model with fewer columns makes everything easier. You're less likely to create incorrect relationships or write overly complex formulas when you're only working with essential data.

Essentially, filtering your columns is like tidying up your workspace before starting a big project. It removes distractions and helps you work more efficiently.

Filtering Columns in Power Query: The Best Method

The best place to remove columns is in the Power Query Editor. Any action you take here is a permanent transformation step for your report’s dataset. This means the columns are removed before they are even loaded into your Power BI data model, giving you the full performance benefits.

First, open the Power Query Editor by clicking on “Transform data” on the Home ribbon in Power BI Desktop.

Once you’re in the editor, you have two primary methods for filtering columns: Choose Columns and Remove Columns. Let’s look at both.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Using “Choose Columns” (Best for Wide Datasets)

The "Choose Columns" feature is perfect when you have a gigantic dataset with dozens or even hundreds of columns, but you only need a handful of them. Instead of specifying every column you want to get rid of, you simply specify the few you want to keep.

Here’s how to do it:

1. Navigate to the “Home” tab in the Power Query Editor.
2. In the "Manage Columns" section, click on the “Choose Columns” icon.
3. A dialog box will pop up, showing a list of every column in your table with a checkbox next to it.
4. By default, all columns are selected. Click the “(Select All)” checkbox at the top to deselect everything at once.
5. Now, go through the list and check the boxes only for the columns you want to keep. For example, if you imported sales data, you might only need ‘[OrderID]’, ‘[OrderDate]’, ‘[CustomerName]’, ‘[Product]’, ‘[Quantity]’, and ‘[Price]’.
6. Click “OK”.

Power Query will apply the step, and your table will now only display the columns you selected. This is by far the most efficient way to slim down a wide spreadsheet or database export.

A Pro Tip for "Choose Columns"

Using "Choose Columns" also makes your query more robust. If your data source is ever updated with new columns that you don't need, your Power Query script won’t import them. Because you explicitly chose which columns to keep, any future additions are ignored by default. This prevents your report from breaking or getting bloated unexpectedly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Using “Remove Columns” (Best for a Few Unwanted Columns)

If your dataset is mostly clean and you just want to get rid of one or two extra columns (like a ‘Notes’ field or a redundant ‘ID’ column), the "Remove Columns" feature is faster.

Here’s the process:

1. In the Power Query Editor, find the column you want to remove.
2. Click on the column header to select it. To select multiple columns, hold down the Ctrl key while clicking each header.
3. Once your columns are selected, you have two options:

The selected columns will instantly disappear. Power Query records this in the "Applied Steps" pane just like any other transformation.

Be Aware of "Remove Other Columns"

When you right-click a column header, you'll also see an option for "Remove Other Columns." This does exactly what it says: it deletes every column except the one(s) you have selected. It's essentially a shortcut for the "Choose Columns" workflow, useful for when you only need to keep one or two.

Hiding Columns in the Report View: A Quick Alternative

Sometimes you need a column in your data model, but you don't want it cluttering up the "Fields" pane for yourself or other report creators. This is common for columns used in the background for calculations, relationships, or sorting, but not for direct visualization.

In this case, you don’t want to remove the column in Power Query, you just want to hide it from the report canvas.

Here’s the difference:

• Removing (Power Query): The column is gone from the model entirely. It doesn't use memory and cannot be referenced in DAX calculations.
• Hiding (Report View): The column is still part of the model and can be used in measures and relationships, but it’s not visible in the "Fields" list when designing your report.

When should you hide a column?

• Sorting Columns: A great example is when you have a column for "Month Name" (e.g., "January", "February"). If you use this in a chart, Power BI will sort it alphabetically ("April", "August", "December"). To fix this, you add a numeric "Month Number" column (1, 2, 3...) and use the "Sort By Column" feature. After setting that up, you don't need anyone to see the "Month Number" column, so you can hide it.
• Primary or Foreign Keys: You need columns like ‘ProductID’ to create relationships between your sales table and your product lookup table, but you rarely want to put the raw ID on a chart. Hiding it keeps the report view cleaner.
• Columns Used Only in Measures: If you have a ‘Unit Cost’ and ‘Unit Price’ column that you only use to calculate a ‘Profit’ measure, you might hide the original columns to encourage users to use the vetted ‘Profit’ measure instead.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Hide a Column

1. Exit the Power Query Editor and go to the Model View or Data View in Power BI Desktop.
2. In the "Data" pane on the right, find the column you want to hide.
3. Right-click on the column name and select "Hide". You can also click the small eye icon next to the column.

The column will be grayed out, indicating it's hidden from the Report View. It’s a simple trick that goes a long way toward creating a user-friendly reporting experience.

Best Practices for Managing Columns

As you get more comfortable working with Power BI, keep these simple rules in mind for a smooth workflow:

1. Prioritize Power Query for Removal: Always default to removing columns in Power Query, not hiding them. It’s the single best thing you can do for your report's performance and efficiency. Hiding is the exception, not the rule.
2. Filter as Early as Possible: Make column removal one of the very first transformation steps in your Power Query workflow. Doing this upfront makes subsequent steps faster and simplifies your preview.
3. Check Your Applied Steps: Power Query automatically documents everything you do in the "Applied Steps" pane. You can click on any step to see what the data looked like at that stage or click the gear icon to modify your selections (for example, to add back a column you chose to remove).

Final Thoughts

Mastering column filtering is a fundamental skill that every Power BI user needs. By using Power Query to remove unnecessary data and the "Hide" feature to clean up your design interface, you are creating a foundation for reliable, fast, and easy-to-use reports that your entire team can benefit from.

Setting up these processes in Power BI is incredibly powerful, but it often involves manual steps across different tools and platforms just to get your data in a single place. We built Graphed to remove that friction entirely. By connecting directly to your data sources like Google Analytics, Shopify, or Salesforce, you don't even have to think about which columns to choose or remove. You just ask for what you need - "show me revenue and ad spend by campaign from Facebook Ads" - and our AI instantly builds a real-time dashboard with only the relevant data, saving you from all the cleaning and prep work so you can get straight to the insights.