How to Select Multiple Items in Tableau Dashboard

Building an interactive dashboard in Tableau is great, but its real power is unlocked when you let your audience explore the data on their own. One of the most common ways to enable this is by allowing them to select multiple items at once to filter or highlight what's important. This article will walk you through several methods for enabling multi-select functionality in your Tableau dashboards, from simple filter controls to more advanced interactive actions.

Why Multi-Select is a Game-Changer for Dashboards

Allowing users to select multiple items isn't just a technical feature, it's a fundamental tool for deeper analysis. Imagine you're a marketing manager looking at campaign performance. Viewing one campaign at a time is useful, but comparing the combined performance of your "Email" and "Social Media" campaigns against "Paid Search" requires selecting multiple items. A sales leader might want to see the total revenue from the "East" and "West" regions combined, excluding all others.

Multi-select transforms a static report into a dynamic analytical tool. It empowers users to:

• Compare Segments: Analyze groups of categories, products, or regions against each other.
• Isolate Trends: Focus on a specific subset of data to see trends more clearly without the noise of irrelevant information.
• Create Custom Groups on the Fly: Dynamically build and analyze a group of items without needing to hard-code a formal group in the data source.

Ultimately, a robust multi-select option makes your dashboard more intuitive and encourages users to ask and answer their own questions.

The Easiest Method: Using Built-in Filter Controls

The most straightforward way to allow multiple selections is by using Tableau's native filter options. This method is perfect for quick setups and dashboards where users need a clear, traditional list to choose from.

Step-by-Step Guide to Multi-Select Filters

Let's say you have a dashboard showing sales by product category and you want viewers to be able to select multiple categories.

1. Add the Dimension to Filters: On your worksheet, find the dimension you want to use as a filter (e.g., Product Category) and drag it to the Filters card.
2. Initial Filter Selection: A dialog box will appear. You can select "All" to include all items by default or pick specific ones. Click OK.
3. Show the Filter: Right-click the Product Category pill on your Filters card and select Show Filter. The filter control will now appear on the right side of your worksheet view.
4. Choose a Multi-Select Option: Click the small dropdown arrow on the top right of the filter card that just appeared. Here you'll see a list of layout options. For multi-select, you'll want to choose either:

Now, when you add this worksheet to your dashboard, the filter control will come with it. Users can simply check the boxes for the items they want to see. By default, they check something and the view updates. To select several at once, they can use Ctrl + Click (PC) or Command + Click (Mac) to click multiple checkboxes before the dashboard refreshes.

Pro Tip: Taming the Automatic Refresh

Sometimes, having the dashboard update after every single click can be slow or distracting. You can add an "Apply" button to the filter.

Click the dropdown on the filter card, go to Customize, and check Show Apply Button. Now, users can check and uncheck multiple boxes, and the dashboard will only update when they click "Apply," making the experience much smoother.

A More Interactive Approach: Using Dashboard Actions

If you want a more visual and fluid user experience, dashboard actions are the answer. Instead of a separate filter list, users can click directly on the marks in one chart (like bars on a bar chart or states on a map) to filter or highlight other charts on the dashboard.

This method has a great "secret weapon": users can simply click and drag to "lasso" an entire group of marks to select them all at once.

How to Create a Multi-Select Filter Action

Imagine you have a map of the United States (your source sheet) and you want to filter a bar chart of sales by product category (your target sheet) by clicking on one or more states.

1. Navigate to Dashboard Actions: Once both worksheets are on your dashboard, go to the top menu and select Dashboard > Actions....
2. Add a Filter Action: In the Actions window, click the Add Action dropdown and select Filter.... This opens the configuration window.
3. Configure the Action:
4. Click OK: Click OK to close the dialog boxes.

Now, go back to your dashboard. Click a state — the bar chart filters. Hold Ctrl and click a few more states — the bar chart shows the combined data for all selected states. Or, click and drag your mouse across a region on the map — all states in your selection are now used as a filter. It's a much more engaging way to explore the data.

How to Create a Multi-Select Highlight Action

A highlight action is very similar to a filter but serves a different purpose. Instead of making non-selected data disappear, it simply fades it into the background, keeping it for visual context. This is fantastic for seeing a particular segment's contribution to the whole. The setup is almost identical to a filter action — just select Add Action > Highlight... in step 2.

Advanced Control: Using Set Actions for Dynamic Viz

When you need even more power and flexibility, Set Actions are the way to go. A "Set" in Tableau is a custom field that divides your data into two groups: values that are IN the set and values that are OUT. A Set Action lets you dynamically change which values are IN the set just by clicking on them.

This unlocks incredibly powerful "IN vs. OUT" analysis, like comparing the performance of selected products against all other products combined.

Step-by-Step Guide to Set Actions for Multi-Select

Let's create a view that allows a user to select several product Sub-Categories to color them differently from the rest.

1. Create the Set: In your data pane, find the dimension you want to analyze (e.g., Sub-Category). Right-click it and choose Create > Set. Name it something like "Selected Sub-Category Set". Leave the set empty for now and click OK.
2. Build Your Worksheet: Create a bar chart showing Sales by Sub-Category.
3. Use the Set: Drag your new "Selected Sub-Category Set" from the data pane onto the Color shelf on the Marks card. Now you'll see two colors: one for items "In" the set and one for items "Out." Right now, everything is "Out".
4. Create the Dashboard Action: Navigate to your dashboard and go to Dashboard > Actions.... Click Add Action > Change Set Values....
5. Configure the Set Action:
6. Click OK: Close the dialog boxes.

Voilà! Go to your dashboard and start interacting. Hold Ctrl and click on several bars. You'll see them instantly change color as they are dynamically added to the IN group of your set. This allows you to create far more sophisticated, user-driven comparisons than simple filters can provide.

Final Thoughts

Enabling multi-select in Tableau turns your dashboards from static galleries into interactive workbenches for analysis. For straightforward filtering, built-in controls are fast and effective. For a more visual and engaging experience, filter and highlight actions let users explore by direct interaction. And for advanced, custom comparisons, set actions provide a level of dynamic control that can truly elevate your analytics.

We know that getting these kinds of interactions right can take time and involves a significant learning curve with complex tools. That's why we built Graphed to simplify the entire process. Instead of navigating menus to configure sets and actions, you can connect your data sources and simply use plain language to tell our AI what you need - like, "Show me a comparison of revenue from my top five products versus all other products this quarter." We handle the difficult setup in seconds so you can get directly to the insights you need without spending hours building reports.