How to Unhide Fields in Power BI

Hiding a field in Power BI is wonderfully simple, but bringing it back can feel like a game of hide-and-seek if you don’t know where to look. While hidden fields are fantastic for cleaning up your data model, you'll inevitably need to unhide one, whether it's for a new calculation or a new visual. This guide will walk you through exactly how to unhide fields, rows, and columns in Power BI Desktop, so you can spend less time searching and more time analyzing.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Hide Fields in Power BI in the First Place?

Before jumping into the "how," let's quickly cover the "why." Hiding fields isn't about deleting data, it's about creating a better, cleaner experience for anyone building reports. A cluttered Fields pane full of unnecessary technical columns can be intimidating and lead to mistakes.

Here are the most common reasons to hide fields:

• Simplifying the Data Model: You might have duplicate fields or IDs that are only used to create relationships between tables (like UserID_FK). Hiding them makes the model less confusing for report builders who only need user-friendly fields like User Name.
• Hiding Measures or Columns Used for Calculations: Often, you'll create columns or simple measures that are just stepping stones for a more complex final measure. Hiding these intermediate calculations prevents them from being used incorrectly in visuals.
• Improving Report Performance: While hiding a column doesn't remove it from the model, it does signal to users not to use high-cardinality fields (columns with lots of unique values) unnecessarily, which can help keep reports running smoothly.
• Managing Redundancy: If you have "Sales Amount" and "Total Sales" that represent the same value, you can hide one to ensure consistency across all reports.

In essence, hiding unused or technical fields is an important part of good data modeling that makes your Power BI file easier for everyone to work with.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

A Quick Refresher: How to Hide a Field

Just so we're all on the same page, hiding a field is a straightforward process you can do from a few different places in Power BI Desktop.

Simple step-by-step instructions:

1. Navigate to either the Report view, Data view, or Model view.
2. In the Fields pane on the right-hand side, find the field you want to hide.
3. Right-click on the field name.
4. From the context menu, select Hide.

Once hidden, the field will be greyed out in the Data and Model views and will completely disappear from the Fields pane in the Report view. This last part is what trips people up - if you can’t see it, how do you unhide it?

How to Unhide a Single Field in Power BI Desktop

Because hidden fields vanish completely from the Report view, you have to switch to one of the other views where they remain visible, just greyed out. The Model view is generally the best place to manage your entire data model, including hiding and unhiding fields.

The Best Method: Unhiding from the Model View

The Model view gives you a high-level overview of your data relationships and is the most intuitive place to manage field properties.

1. Click the Model view icon on the far-left bar. It looks like three boxes connected by lines.
2. In the Fields pane on the right, locate the table that contains your hidden field.
3. Scroll through the list of fields. The hidden field will be greyed out and have a small icon of an eye with a slash through it.
4. Right-click on the greyed-out field name.
5. From the context menu, select Unhide.

That's it! The field will immediately return to its normal state, the eye icon will disappear, and it will become visible again in the Report view, ready to be used in your visuals.

Another Great Option: Unhiding from the Data View

The process in the Data view is nearly identical and is a matter of personal preference.

1. Click the Data view icon on the far-left bar. It looks like a spreadsheet.
2. In the Fields pane on the right, find your table.
3. Find the greyed-out field you wish to make visible.
4. Right-click the field name and select Unhide.

You can use whichever view you're most comfortable in. Neither view is "better" than the other for unhiding a single field.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How to Unhide Multiple Fields at Once

If you have a whole list of fields to unhide - maybe you imported a new table and Power BI automatically hid a bunch of them - unhiding them one by one is a drag. Thankfully, you can perform this action in bulk.

This works best in the Model view.

1. Go to the Model view.
2. In the Fields pane, find the table with the multiple hidden fields.
3. Click on the first hidden field you want to unhide.
4. Hold down the Ctrl key (or Cmd on a Mac) on your keyboard.
5. While holding the key, click on every other hidden field you want to include in a single action. They will all become highlighted.
6. Once you've selected all the desired fields, right-click on any one of the highlighted fields.
7. Select Unhide from the menu.

All the fields you selected will be unhidden simultaneously, saving you a lot of repetitive clicking.

Can You Unhide All Fields in a Table at Once?

While Power BI doesn't have a single "Unhide All" button for an entire table, the multi-select method is the next best thing. Instead of clicking individual fields, you can select the top field in a hidden sequence, hold the Shift key, and then click the last field to select all of them in between. Then, just right-click and choose "Unhide."

Unfortunately, you cannot simply right-click the table name and choose "Unhide all fields." This action must be performed on the fields themselves.

A Quick Clarification: "Hiding Fields" vs. "Filtering Data"

The term "unhide" can sometimes be confusing in Power BI because it can apply to different contexts. It's important to understand the difference between hiding a column in your data model versus filtering rows out of a visual.

• Hiding a Field/Column: This is a data modeling action. When you hide a field, you are removing it from the Report view's Fields pane. It still exists in your dataset but is not available for building new visuals unless you unhide it. This affects the entire PBIX file.
• Filtering Rows of Data: This is a reporting action. When you use the Filters pane to, for instance, only show data for "2024," you are temporarily hiding rows from a specific visual or page. The other year's data is still loaded in the model and the "Year" field is still available. To "unhide" these rows, you simply remove the filter in the Filters pane.

So, if a specific row or value is missing from your table visual (e.g., a specific product isn't showing up), first check the Filters pane applied to that visual. The product might be filtered out. If the entire "Product Name" column is missing from your choices in the Fields pane, then it's been hidden at the model level, and you need to use the steps outlined above.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Final Thoughts

Keeping a clean, organized data model is essential for building effective Power BI reports, and hiding fields is a big part of that. Now you know that unhiding is just as easy once you remember to step out of the Report view and into the Model or Data view. Using these views, you can unhide a single field or multiple fields at once, ensuring your dataset is always perfectly curated for your reporting needs.

While managing a detailed data model offers a lot of control, it can also feel like a throwback to a time when data was only accessible to technical users. At Graphed, we think you should be able to get answers from your data without first having to become a part-time data modeler. We built an AI data analyst that lets you connect your data sources - like Google Analytics, Shopify, and Salesforce - and then simply ask for what you need in plain English. No more hunting for hidden fields because our platform handles the complexity, pulling from the right data points to build real-time, interactive dashboards for you in seconds.