How to Search in Tableau
Finding the exact data point, sheet, or dashboard you need in Tableau can sometimes feel like a treasure hunt. Unlike a web browser with one central search bar, Tableau offers several targeted search and filter features designed for specific tasks. This guide will walk you through exactly how and where to search in Tableau to quickly locate anything from a specific customer in a chart to a long-lost field in your data source.
Start with the Global Workbook Search
When you have a large and complex workbook with dozens of sheets, dashboards, and stories, the best place to start is the Workbook Search. This is the closest thing Tableau has to a universal search bar.
You can find it by clicking the magnifying glass icon in the top-right corner of the toolbar. The moment you open it, you get a clean interface that allows you to start typing immediately.
This search tool will look through:
- Worksheet names
- Dashboard titles
- Story titles
- Field names (Dimensions and Measures)
- Captions and titles within your views
Simply type your keyword and Tableau will display a list of every matching item, categorized by what it is (e.g., dashboard, worksheet, field). Clicking a result will instantly take you to that location. It’s the fastest way to navigate a workbook you didn't create or a very large one you're collaborating on.
Example: You join a new team and are reviewing a massive workbook with hundreds of data sources and dozens of dashboards. Instead of clicking through every tab, you can simply open the Workbook Search and type "Revenue" to see every worksheet and dashboard related to revenue performance.
Searching Inside Your Views and Dashboards
Once you’re on a specific dashboard or worksheet, your focus shifts from finding the right sheet to finding the right data point within it. Tableau provides several methods for this, each suited for a different purpose.
Method 1: Using the Filter Card for Quick Searches
The most common way to search for specific values within a visualization is through the Filter card. When you filter by a dimension with many unique values (like "Customer Name" or "Product SKU"), Tableau automatically gives you a search box within that filter card.
Here’s how to use it:
- Add the Field to Filters: Drag the dimension you want to search (e.g.,
Product Name) onto the "Filters" shelf. - Show the Filter: After the filter options box appears, make any necessary selections and click OK. Then, right-click the field's pill on the Filters shelf and select "Show Filter." A filter card will now appear on your worksheet or dashboard view.
- Customize the Filter: By default, it might be a list. Click the small dropdown arrow on the filter card's title bar and select a "Wildcard Match" or "Multiple Values (Custom List)" type. The wildcard match is especially powerful for searching.
- Start Searching: Just type into the filter's search box. For example, typing "Chair" will instantly filter your product list view to show only the products with "Chair" in their name.
This method is fantastic for creating interactive dashboards where end-users can easily find the specific items they care about without being overwhelmed by thousands of rows of data.
Method 2: Highlighting Data for Visual Search
Sometimes you don't want to filter out data, but rather highlight specific data points within the context of the whole. This is incredibly useful in visualizations like maps or scatter plots.
You can enable a highlighter in a similar way to showing a filter:
- Find the dimension color-coding your chart in the Marks card or on another shelf (like Detail). For example, if you have a map of the US with each state colored by sales region, the
Regionfield would be on the Marks card. - Right-click that field pill and select "Show Highlighter."
- A highlighter search box will appear, letting you or your users type in a value (like "West") to instantly highlight all marks associated with that region, while the others fade into the background.
Method 3: Creating a Parameter for a Dashboard-Wide Search Box
For a more advanced and integrated search experience, you can create a dedicated search box using a parameter. This gives you a single, clean search field on your dashboard that can filter one or more worksheets simultaneously.
This is a three-step process:
Step 1: Create the Parameter
- In the Data pane, click the dropdown arrow at the top and select "Create Parameter..."
- Give it a name, like "Search Products."
- Set the "Data type" to String.
- Set "Allowable values" to All. This turns it into an open text field.
- Click OK. Then, right-click the parameter in the Data pane and select "Show Parameter." Your search box now appears on the sheet.
Step 2: Create the Calculated Field
The parameter doesn't do anything on its own. It needs a calculated field to link its input to your data:
- Click the dropdown in the Data pane again and select "Create Calculated Field..."
- Name it something like "Search Filter."
- Enter a formula that checks if your text field contains the parameter's string. The formula looks like this:
CONTAINS([Product Name], [Search Products])
This formula returns "True" if the Product Name contains the text entered into the "Search Products" parameter and "False" otherwise.
Step 3: Apply the Filter
- Drag your new calculated field ("Search Filter") onto the Filters shelf.
- In the filter pop-up, check the box for "True" and click OK.
Now, anything you type into the "Search Products" parameter box will filter your view to only show records where the name contains your search term. This is a very clean and professional way to add search functionality to a final dashboard.
Searching Your Available Data (Data Pane)
When you're in the process of building a worksheet, you're constantly looking for the correct dimensions and measures to drag into your view. When your data source has hundreds of fields, scrolling is inefficient. Use the search bar at the very top of the Data pane instead.
This search bar is purely for finding fields — it doesn't search the data within those fields. It's an essential tool for an efficient building process.
Example: You need to add customer information but can't remember if the field is named Cust ID, Customer ID, or Customer_Identifier. Just type "customer" into the Data pane search box, and Tableau will instantly show you all fields containing that word.
Searching Tableau's Menus and Options
Ever know that a feature exists but can't remember which menu it's hiding in? Instead of clicking through File, Format, Data, and Analysis, use the Help menu search.
Go to the Help menu in the top navigation bar and use the search box there. This will search through all of Tableau's features, options, and documentation. For example, if you want to change the grid lines on your chart, just type "grid lines" into the Help search. It will immediately show you the menu path to that function (Format > Lines... > Grid Lines).
Final Thoughts
Mastering these various search functions will transform you from someone who slowly clicks around into a fast and proficient Tableau user. The key is knowing which tool to use for the job: the global workbook search for navigation, filter cards and highlighters for exploring data, and the data pane search for building views.
While Tableau gives you many powerful ways to search within a highly structured dashboard environment, this approach requires you to manually build every view before you can explore it. Here at Graphed, we created a tool for teams who want to get straight to the answers. By connecting your sources like Google Analytics, Shopify, or ads platforms, you can use natural language - just like talking to a data analyst - to instantly build dashboards and ask follow-up questions. Instead of learning to search, you just ask, turning hours of building and filtering into a simple, 30-second conversation with your data.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.