How to Unhide Columns in Tableau Data Source
It happens to everyone. You’re working in Tableau, trying to clean up your data source, and you confidently right-click and hide a few columns you don’t think you’ll need. Then reality sets in: you actually do need one of those fields, but it’s nowhere to be found. This article will show you exactly how to find and unhide those missing columns on both the Data Source page and directly within your worksheet’s Data pane.
Why Did My Column Disappear? The Basics of Hiding Fields
In Tableau, hiding a column (or "field," as Tableau calls it) is a common way to simplify your view. When you have a data source with dozens or even hundreds of columns, it's easy to get overwhelmed. Hiding fields you don't plan to use can make your Data pane much easier to navigate.
The usual way a field gets hidden is by right-clicking it on either the Data Source page or in the Data pane of a worksheet and selecting Hide. This action doesn't delete the column from your data set, it just tucks it out of sight, removing it from view in your worksheets. The problem is, Tableau does such a good job of hiding it that it can feel like it vanished completely. But don’t worry, it’s still there, and getting it back is straightforward once you know where to click.
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.
Method 1: Unhiding Columns on the Data Source Page
The most direct place to manage your fields is on the Data Source page. This is the screen where you first land after connecting to your data and where you can see your data in a grid view. It’s the perfect place to see everything at a glance, including your hidden fields.
Follow these steps to unhide columns from this view:
- Navigate to the Data Source Page: If you're currently in a worksheet, look at the bottom-left corner of your Tableau window. You'll see several tabs. Click on the Data Source tab to return to the data grid.
- Locate the Settings Gear Icon: In the upper-right corner of the data grid, you'll see a small gear icon labeled "Manage metadata." Click on it. This is where you control how your fields are displayed in this grid.
- Select "Show Hidden Fields": After clicking the gear icon, a dropdown menu will appear. Make sure the option for Show Hidden Fields is checked. If it isn't, click it.
- Identify and Unhide the Column: Once "Show Hidden Fields" is enabled, your hidden columns will reappear in the data grid. You can easily spot them because they will be grayed out. Find the column you need, right-click on the column name, and select Unhide from the context menu.
The column will immediately return to its normal state - no longer grayed out - and will be available for use across all your worksheets. This method is incredibly useful if you’ve hidden several fields and want to unhide them all at once without having to hunt for them in the Data pane.
Imagine you have an e-commerce dataset and hid the Order Priority column to simplify your initial view. Now, you need to analyze rush orders. By going to the Data Source page, clicking the gear icon, and checking "Show Hidden Fields," you'll immediately see the grayed-out Order Priority column, ready to be brought back into your analysis.
Method 2: Unhiding Directly from the Data Pane
Sometimes you’re deep into building a dashboard and realize you need a field you hid earlier. You don’t have to disrupt your workflow by navigating back to the Data Source page. You can unhide fields directly from the Data pane right inside your worksheet.
Here’s how to do it:
- Go to Your Worksheet: Open any sheet in your Tableau workbook.
- Find the Data Pane: This is the panel on the far left that lists all your tables, dimensions, and measures.
- Click the Dropdown Arrow: At the very top right of the Data pane, next to the search bar, there is a small dropdown arrow (in older versions, it might be a gear icon). Click on it.
- Select "Show Hidden Fields": In the dropdown menu that appears, click on Show Hidden Fields. Just like on the Data Source page, your hidden fields will now appear in the Data pane, grayed out.
- Unhide Your Desired Field: Scroll through the list of dimensions and measures to find the grayed-out field you want back. Right-click on it and select Unhide.
The field will instantly become active and available to drag and drop into your visualizations. This is generally the faster method if you only need to unhide one or two fields and want to stay in your current thought process.
Troubleshooting: What if "Show Hidden Fields" Doesn't Bring My Column Back?
In most cases, one of the two methods above will solve your problem. However, there are a few scenarios where a field might seem to have disappeared for other reasons. If you’ve tried to unhide your field and it’s still missing, here are a few things to check.
Check for Data Source Filters
A data source filter can restrict the data being pulled into Tableau from your source. If you have a filter that excludes all the values associated with the column you’re looking for, the column might appear to be empty or missing. For example, if you set a data source filter on a Country column to only include "USA" and the column you’re missing is Canadian Province, that province column will contain only null values. In that case, the field isn't technically hidden, it's just filtered out.
- How to check: Go to the Data Source page. In the top right corner, you'll see a "Filters" link. Click it to view and edit any active data source filters.
The Column Was Removed from the Original Data Source
This is a very common issue. You build a dashboard using a dataset from an Excel file or a database view. Later, you or someone on your team updates that source file and removes a column. The next time you open Tableau and refresh your data, the field you were using is gone.
Tableau alerts you to this by showing the field in the Data pane with a red exclamation point (!) next to it. This means Tableau remembers the field but can no longer find it in the current data source.
- How to fix: Your options are to either add the column back to the original file and refresh the data source in Tableau, or accept that it's gone and remove it from your workbook. To remove it, right-click the field with the red exclamation point and select Delete. You’ll also have to fix any calculations or charts that were using it.
Try Refreshing the Data Source
Sometimes, the connection between Tableau and your data source just needs a quick reset, especially if changes have recently been made to the underlying data. Refreshing the data source forces Tableau to re-examine the source file or database to see what’s there.
- How to refresh: Go to the Data Source page and click the small, circular arrow icon at the top next to your connection name. Alternatively, you can right-click on your data source in the Data pane and select Refresh. This can sometimes make "lost" columns magically reappear if they were recently added to the source.
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.
A Better Habit: Use Folders Instead of Hiding
While hiding fields can be useful, over-hiding can lead to the very problem this article addresses: forgetting what you hid and where to find it. A better long-term strategy for managing a large number of fields is to organize them using folders in the Data pane.
You can create folders to group related fields, decluttering your view without making anything inaccessible. For example, in a sales dataset, you could create folders like "Customer Info," "Order Details," and "Product Dimensions." This keeps your primary view clean while ensuring every field is just a click away.
To create a folder, simply right-click in an empty space in the Data pane and select Group by Folder. From there, you can create new folders and drag your fields into them.
Final Thoughts
Losing track of a column in Tableau can be frustrating, but the solution is usually just a few clicks away. Whether you prefer revealing columns on the Data Source page or directly in the worksheet's Data pane, the "Show Hidden Fields" setting is your reliable tool for bringing them back. By understanding why fields disappear and where to find this setting, you can keep your data organized without losing access to what you need.
Managing data schemas and wrangling reports is a big reason people spend so much time in tools like Tableau to begin with. The complexity of hidden fields is often a symptom of the larger challenge: your valuable marketing and sales data is scattered across a dozen different platforms. Here at Graphed , we solve this by making the process incredibly simple. We connect directly to your data sources like Google Analytics, Shopify, and Salesforce, and let you create entire dashboards just by asking questions in plain English. Instead of hunting for a "hidden" column, you can just ask, "Show me last month's revenue by campaign," and get an answer instantly.
Related Articles
Facebook Ads for Carpet Cleaners: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for carpet cleaning businesses in 2026. Get proven strategies for targeting, creative formats, retargeting, and budget that actually convert.
Facebook Ads For Personal Trainers: The Complete 2026 Strategy Guide
Learn how to effectively use Facebook ads for personal trainers in 2026. This comprehensive guide covers targeting strategies, ad creative, budgeting, and optimization techniques to help you grow your training business.
Facebook Ads for HVAC Companies: The Complete 2026 Strategy Guide
Learn how to run high-converting Facebook ads for HVAC companies in 2026. This guide covers targeting, creative strategies, and proven campaigns that drive real leads.