How to Select All in Tableau

Selecting all your data points in a Tableau view seems like it should be simple, but it can be one of those surprisingly finicky actions that new users stumble over. Whether you're trying to highlight data, create a set, or view the underlying numbers, knowing how to do a "select all" is a fundamental skill. This guide will walk you through several easy methods for selecting all marks, from keyboard shortcuts to more advanced techniques for dashboard interactivity.

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 Would You Need to Select All Marks?

Before jumping into the "how," it's helpful to understand the "why." Selecting marks (the data points in your visualization like bars, circles, or points on a map) is the first step toward several common analysis actions. You aren't just selecting them to stare at them, you're doing it to take the next step.

1. Creating Sets for Deeper Analysis

One of the most powerful reasons to select marks is to create a static set. You can group records together on the fly to use them in other parts of your analysis. For example, you might look at a scatter plot of campaign performance, select all the campaigns that meet a certain visual criteria (e.g., high ROI), and group them into a "Top Campaigns" set. This new set can then be used as a dimension to filter other sheets or in calculations.

2. Highlighting Data to Tell a Story

When presenting your dashboard, highlighting is a key feature for drawing your audience's attention. Selecting a group of marks - or all of them - allows you to emphasize specific parts of your data. Imagine clicking on a legend item for "North America" sales, selecting and highlighting that group of data points on a map makes your narrative much clearer than just pointing at a screen.

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

3. Quick Filtering with "Keep Only" or "Exclude"

Selections are the foundation of ad-hoc filtering. If you have a chart with hundreds of products, you could select all the ones from a single supplier and click the "Keep Only" tooltip command to instantly filter your view down to just those items. Conversely, you could select a group of outlier products and hit "Exclude" to remove them from your view to get a better look at the rest of your data. This is often much faster than building out a formal filter from the Filters Pane.

4. Viewing the Underlying Data

Tableau visualizations are summaries of mounds of raw data. Sometimes, you need to see the actual rows and columns that make up a particular bar or point in your chart. By selecting one or more marks and using the "View Data" command, you can inspect the exact records powering that part of your visualization. Selecting all marks lets you see the summarized or full underlying data for everything in your current view.

3 Great Methods for Selecting All Marks in a Tableau View

Now that we know why it's useful, let's cover the three most common ways to select all the marks on your worksheet. The best method often depends on your specific visualization and personal preference.

Method 1: The 'Click and Drag' Selection Box

This is the most direct and visual method. Tableau gives you several tools to draw a selection area right over your data points.

1. On the worksheet's View Toolbar (usually appears when you hover near the top of the sheet), you'll see a series of navigation tools. Look for the selection tool, which defaults to a rectangle.
2. You can click the small arrow next to it to switch between 'Rectangular,' 'Lasso' (freeform drawing), and 'Radial' selection.
3. Once your preferred tool is chosen, simply click in an empty area of your visualization and drag the box (or shape) until it covers all the marks you want to select.

When to use this: This method is fantastic for visual selections, especially on maps or scatter plots where you can easily eyeball the group you want to select. It's intuitive and requires no memory of shortcuts.

Potential drawback: On very dense or complex visualizations, it can be easy to accidentally miss a few outlying marks hidden in a corner. You may need to pan or zoom to ensure everything is covered by your selection box.

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: The Universal Keyboard Shortcut (Ctrl+A / Cmd+A)

Almost everyone who has used a computer knows this shortcut. It’s the fastest and most comprehensive way to select everything.

1. First, make sure the worksheet you want to interact with is active. Click on an empty space inside the main visualization pane of the sheet (not on a filter, legend, or title).
2. Press Ctrl+A on a Windows machine or Cmd+A on a Mac.

Instantly, all the marks within that active sheet will be selected and highlighted. This is often the most reliable way to ensure you haven't missed a single data point.

When to use this: This is the go-to method for nearly any situation. It's perfect for dense visualizations where a drag-select might be clumsy and is guaranteed to get every single mark in the view.

Potential drawback: The only real pitfall is forgetting the first step. If you click on a color legend or a quick filter before pressing Ctrl+A, it may not work. The shortcut applies to the currently active pane, so clicking inside the actual chart area is crucial.

Method 3: Group Selection Using a Legend

Sometimes you need to select everything, but you want to do it group by group. Using the legend is a clean way to accomplish this and helps confirm you've got all categories.

1. Locate the legend that corresponds to the categories you want to select (e.g., a color legend for Region or a shape legend for Product Category).
2. Hold down the Ctrl key (or Cmd key on Mac).
3. While holding the key, click each item in the legend one by one. As you click each, all marks belonging to that category will be added to your selection.

When to use this: This is ideal when your "select all" operation is really a "select all of these specific categories." It gives you more granular control and is useful when you want to group all but one or two categories. It confirms that you're selecting members of a category rather than just visually grabbing points on a screen.

Potential drawback: If your legend is extremely long (dozens or hundreds of items), this method becomes highly impractical and tedious. In that case, Ctrl+A is a far superior option.

Advanced Use Case: Creating a "Select All" Option in a Filter

The techniques above are for selecting marks already visible in your view. But what about providing a "Select All" option within a filter for your dashboard users? This is a different but related concept and one of the most common requests from end-users.

You can achieve this by using parameters and a calculated field to add an "All" option to what feels like a filter.

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

Step 1: Create the Parameter

First, create a new parameter. Let's call it "Region Parameter."

• Set the 'Data type' to String.
• Choose 'Allowable values' as List.
• In the 'List of values' section, type "All" and press Enter.
• Then, click 'Add values from' and choose your dimension (e.g., "Region"). This will populate the list with all of your regions automatically.
• When finished, Tableau will display the parameter control card.

Step 2: Create the Calculated Field for Filtering

Next, create a calculated field that connects this parameter to your view. You can name it "Region Filter Calculation." The formula will be:

[Region Parameter] = "All" OR [Region Parameter] = [Region]

This calculation does the following:

• It returns TRUE if the user selects "All" in the parameter control.
• It returns TRUE if the parameter selection matches the [Region] for a specific mark.
• It returns FALSE otherwise.

Step 3: Apply the Calculated Field as a Filter

Finally, drag your new calculated field, "Region Filter Calculation," onto the 'Filters' shelf.

• In the filter dialog box that pops up, check the box for True and click 'OK'.

Now, when you use the "Region Parameter" control on your dashboard, your users can either select a specific region to filter the view or choose "All" to see all the data. This provides a clean, user-friendly way to handle a "select all" filtering need.

Final Thoughts

Learning how to select all in Tableau is a fundamental skill that opens the door to more dynamic analysis and clearer data storytelling. We've covered the simple Ctrl+A shortcut, the visual click-and-drag method, and using legends for group selections, while also exploring how to build an intuitive 'All' option for dashboard filters using parameters.

While mastering Tableau is rewarding, it often involves learning numerous clicks, settings, and workarounds to get the answers you need. At Graphed we felt there should be an easier way for teams to get insights from their own data. We built our tool so you can skip the manual setup and complex calculations by just describing what you need in plain English. Instead of building parameters and calculated fields, you can just ask, "Show me my sales data for all regions combined," and get back a live dashboard instantly.