How to Select Multiple Rows in Tableau

Trying to compare specific customers, group related products, or filter out a few outliers in Tableau? The first step is often selecting the multiple rows you want to work with. This article will show you several ways to select multiple rows in Tableau, from simple keyboard tricks to more advanced techniques for interactive dashboards.

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

The Basics: Point-and-Click Selection Methods

Tableau offers a few straightforward ways to select multiple data points directly in your view, whether it's a text table or a visual chart. These methods are the foundation of interactive analysis and are essential for your daily workflow.

Method 1: Ctrl + Click (or Cmd + Click on Mac) for Non-Adjacent Rows

This is your go-to method when you need to hand-pick specific rows that are not next to each other. Imagine you have a sales report and want to compare the performance of 'New York', 'California', and 'Texas'. These states aren't listed consecutively, so this technique is perfect.

How to do it:

• Press and hold the Ctrl key on your keyboard (or Cmd key on a Mac).
• While holding the key, click on each row header (in a text table) or mark (in a chart) that you want to select.
• Each item you click will be highlighted, adding it to your selection.

For example, in a list of product categories, you could hold Ctrl and click on "Technology," "Furniture," and "Office Supplies" to select just those three, even if they have other categories listed between them.

Method 2: Shift + Click for a Contiguous Block of Rows

When the rows you need are all listed together in a sequence, the Shift + Click method is much faster than selecting them one by one. This is ideal for selecting a range, like all sales transactions from a specific week or a Top 10 list of products.

How to do it:

• Click on the first row in the range you want to select.
• Press and hold the Shift key on your keyboard.
• While holding Shift, click on the last row in the range.
• Tableau will automatically highlight the first row, the last row, and every single row in between.

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 3: Drag to Select (Rectangular, Lasso, and Radial Tools)

When you're working with visualizations like scatter plots or maps, selecting rows from a text table isn't an option. Instead, you need to select the marks directly on the chart. Tableau's selection tools make this easy.

Look for these tools in the View Toolbar at the top of your workspace. By default, it's set to Rectangular.

• Rectangular Selection (Default): Click and drag your mouse to draw a box around the marks you want to select. It’s quick and simple for selecting clustered data points.
• Lasso Selection: This tool lets you draw a freeform shape around your desired marks. It’s perfect for selecting data points that are in an irregular shape, letting you neatly avoid outliers that you don't want in your selection.
• Radial Selection: This tool selects all marks within a circular radius from a central point you define. It’s incredibly useful for geographic analysis, like selecting all customer locations within a 50-mile radius of a particular store.

Regardless of which tool you use, the underlying rows of data corresponding to the marks you select will be highlighted and ready for your next action.

What Can You Do After Selecting Rows?

Selecting multiple rows is just the first step. The real power comes from what you do next. Once you have a selection, a tooltip will appear with several options that open up deep analytical possibilities.

Keep Only or Exclude

This is the quickest way to filter your view. After you've selected your rows, hover over one of them to bring up the tooltip. You'll see two powerful options:

• Keep Only: This action instantly filters your dashboard to show only the data from the rows you selected. Anything not in your selection disappears from the view.
• Exclude: This does the exact opposite. It removes the selected rows from your view, which is perfect for cutting out known outliers or irrelevant data points without having to build a complex filter.

Create a Group

Grouping is one of the most common actions after selecting multiple rows. It allows you to combine several members of a dimension into a single category. For example, you could select "Spain," "Germany," "France," and "Italy" and group them into a new dimension member called "EU Core Markets."

To do this, select the rows or marks you want to group, hover to bring up the tooltip, and click the "Group" icon (it looks like a paperclip). You can then name your new group, which will be added to the Data pane as a new field you can use in any visualization.

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

Create a Set

Sets are similar to groups, but they are more powerful and dynamic. A set acts like a custom field that categorizes certain dimension members as either "IN" (part of the set) or "OUT" (not part of the set). Creating a set from a manual selection is a great way to tag customers or products for deeper analysis.

For example, you could create a set of your VIP customers by selecting them from a scatter plot of Sales vs. Profit. You can then use this set in calculations, filters, or other charts to analyze the behavior of your VIPs vs. everyone else. To create a set, select your marks and click the "Sets" icon (it looks like two overlapping circles).

Highlighting

If you have the same field on multiple worksheets in a dashboard, selecting rows in one sheet can highlight the corresponding data in others. This is called 'cross-worksheet highlighting' and is a fantastic way to see relationships in your data. Simply select a few rows in one chart, and you'll immediately see where those same data points fall in your other charts.

Advanced Ways to "Select" Multiple Rows

Sometimes, manual clicking isn't practical, especially with large datasets or the need for user-driven interaction on a published dashboard. Here are some more advanced methods to programmatically select data.

Using a Parameter for Dynamic Selection

Parameters allow users to input a value that can be used to alter a view or a calculation. You can use a parameter to let users "select" a category, and Tableau will visually highlight all rows belonging to that category.

Here’s a simplified approach:

1. Create a Parameter: Create a new parameter, set its data type to String, and populate it with a list of the dimension members you want to select from (e.g., a list of your product categories).
2. Create a Calculated Field: Build a simple calculated field that compares the dimension to the parameter. The formula might look like this:
3. Use the Calculation: Drag this new calculated field onto the Color shelf on the Marks card. Now, when a user selects a category from the parameter control, all rows belonging to it will change color, effectively highlighting your selection across the entire chart.

This method doesn't technically select the rows for actions like "Keep Only," but it’s a brilliant strategy for guiding a user's attention on a busy dashboard.

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

Building Selections with Viz in Tooltip

A very creative method for offering more detailed selections is using the "Viz in Tooltip" feature. You can create a master visualization (like a map of the US) and a secondary visualization (like a bar chart of sales by product category).

You can then configure the tooltip so that when you hover over a state on the map, the tooltip displays the corresponding bar chart for just that state. From that bar chart inside the tooltip, you can then select multiple bars (rows), allowing for a highly contextual, two-layered selection process.

Practical Tips and Common Gotchas

• Losing Your Selections: One of the most common frustrations is carefully selecting twenty different rows with Ctrl+Click, only to accidentally click somewhere else in the view and lose the entire selection. Go slow and be mindful of where your mouse is!
• Row Headers vs. Marks: The available actions can differ based on what you select. Selecting a row header in a text table provides basic options, whereas selecting a mark (a bar, a circle, a geographic shape) typically gives you the full suite of actions including Group, Create Set, Keep Only, and Exclude.
• Performance Issues: Be aware that trying to manually select thousands of individual marks on a complex visualization can sometimes be slow. If you’re working with massive datasets, it’s often more efficient to apply filters first to narrow down your data before making your manual selections.

Final Thoughts

Mastering how to select multiple rows is fundamental to moving from simply viewing data to actively analyzing it in Tableau. Whether you're using a quick Ctrl+Click to compare a few data points, dragging a lasso around a cluster of customers, or setting up a parameter to highlight categories, this skill unlocks filtering, grouping, and deeper data exploration.

While learning these interactive techniques is crucial for tools like Tableau, we understand that clicking, filtering, and manually creating insights can still take time. At Graphed you can streamline this entire process. Instead of manually selecting and grouping data, you can simply ask, "Show me my sales for my top 5 products versus the rest" and get an answer instantly. We connect your data sources so you can turn hours of analysis into a plain-English conversation, getting you straight to the insights and without extensive manual work.