How to Add a Slicer in Tableau Dashboard

While Tableau is a powerful tool for creating beautiful, data-rich dashboards, you might find yourself searching for how to add a slicer, a familiar feature from tools like Power BI or Excel. Here’s the key difference: in Tableau’s world, what you're looking for is called a "Filter." They perform the same function - letting you and your audience dynamically segment and analyze data - and this guide will walk you through exactly how to add, customize, and apply them across your dashboards.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tableau Slicers vs. Tableau Filters: What’s the Difference?

There is no functional difference. It's simply a matter of terminology. Excel and Power BI use the term "Slicer" for interactive controls that filter visuals. Tableau accomplishes the exact same thing but calls these controls "Filters."

So, whenever you think "I need to add a slicer," just remember the word "Filter" in Tableau. These interactive filters are the secret to transforming a static report into an engaging, explorable dashboard that empowers users to find their own answers.

How to Add a Basic Filter (Slicer) to a Tableau Worksheet

Before you can add an interactive slicer to your dashboard, you first need to create the filter on an individual worksheet. Let's start with a simple sales dataset that includes fields like Region, Category, Sub-Category, and Sales.

Our goal is to create a filter for the Region so we can view sales data for specific areas.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Drag Your Desired Field to the Filters Card

In your Tableau worksheet, locate the data field you want to use for filtering. In this case, we'll use the Region dimension. Click and drag the Region pill from the Data pane over to the Filters card, located just above the Marks card.

Step 2: Configure the Filter Settings

Once you drop the field onto the Filters card, a dialog box will pop up. This box lets you set the initial filtering rules. The "General" tab shows a list of all available members in that field (e.g., Central, East, South, West).

Select the members you want to include in your view by default. You can check individual boxes, or just click All to include everything to start. When you’re done, click OK.

Step 3: Show the Filter to Make it Interactive

The field is now acting as a filter, but it isn’t interactive for the end-user yet. To create the visual "slicer" control, right-click the Region pill on your Filters card and select Show Filter.

An interactive filter card will now appear on the right side of your worksheet view. Users can now check or uncheck boxes to dynamically update the visualization on this sheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Dashboard Filter's Appearance

By default, Tableau might show your filter as a list with multiple checkboxes. However, you have several options to customize how it looks on your dashboard, which is essential for saving screen space and creating a better user experience.

On the filter card that appeared on your worksheet, click the small dropdown arrow in its top-right corner. This will reveal a menu of different display options:

• Single Value (List): A radio button list where you can only select one option at a time. Perfect for when you want users to compare things individually (e.g., Region vs. Region).
• Single Value (Dropdown): A compact dropdown menu for selecting one option. Great for long lists where showing all options would clog the dashboard.
• Multiple Values (List): The default option with checkboxes allowing users to select multiple options.
• Multiple Values (Dropdown): A dropdown that lets users check multiple options. Ideal for giving lots of choices without taking up dashboard real estate.
• Single Value (Slider): A slider control. While more common for dates or numerical values, it can be used for dimensions if they have a logical order.
• Wildcard Match: A text input field where users can type to find matching values (e.g., type "Cent" to find "Central").

Choose the option that best fits your dashboard design and the way you expect your users to interact with the data.

Applying One Filter to Multiple Worksheets on a Dashboard

A slicer isn’t very useful if it only controls a single chart. The real power comes from using one filter to update several visuals on your dashboard simultaneously. For instance, a single Region slicer could filter a sales map, a product breakdown bar chart, and a monthly profit trend line all at once.

Here’s how to set that up:

1. First, create your individual worksheets (e.g., one sales map, one product bar chart).
2. Create a filter on one of them as described above but don’t stop there.
3. Go to one of the worksheets that has the filter applied (for example, your sales map with the Region filter). Right-click the filter pill on the Filters card.
4. In the context menu, hover over Apply to Worksheets and then select Selected Worksheets....
5. A dialog box will appear listing all the worksheets in your workbook. Check the boxes for every sheet you want this filter to control. Now, add all of these sheets to your dashboard view. The filter control will appear, and it will now update every worksheet you selected.

Advanced Slicer Types for Your Dashboards

Once you’ve mastered basic dimension filters, you can start building more advanced controls.

Creating a Date Range Slicer

Analyzing data over time is a common requirement, and a date range slider is the perfect tool for this.

1. Drag your date field (e.g., Order Date) to the Filters card.
2. Tableau will ask you to choose how to filter the date (e.g., Relative Date, Range of Dates, Years, Quarters). Select Range of Dates and click Next.
3. Click OK on the next dialog.
4. Right-click the date filter on the card and select Show Filter. Tableau will automatically add an interactive slider that lets users select a start and end date.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Creating Cascading Filters

A common user need is to have one filter update another. For example, after a user selects "United States" from a Country filter, they should only see American states in the State filter - not Canadian provinces too.

This is called a cascading or dependent filter, and you can achieve it with Context Filters.

1. Add your primary filter (e.g., Category) and your secondary filter (e.g., Sub-Category) to the Filters card. Show both filters on the worksheet.
2. Right-click the primary filter pill (Category) on the Filters card and choose Add to Context. The pill will turn grey, indicating its priority.
3. Now, click the dropdown on the secondary filter’s visual card (the Sub-Category slicer) and select Only Relevant Values.

That's it! Now, when a user selects a Category, the Sub-Category filter will instantly update to show only the options within that category.

Best Practices for Using Dashboard Slicers

• Keep it Clean: Don’t overwhelm users with too many filters. One or two primary slicers are often more effective than ten small ones. Group related filters together to create a logical flow.
• Use the Right Layout: For long lists of options, a Multiple Value Dropdown is much cleaner than a list that forces your user to scroll endlessly.
• Use Descriptive Titles: Double-click the title of a filter card on the dashboard to rename it. Instead of "Category," try "Select a Product Category" to give clearer instructions.
• Consider Performance: For extremely large datasets, every filter click can cause the dashboard to reload slowly. To prevent this, you can activate an "Apply" button on the filter. Just go to the filter card's dropdown menu and select Customize > Show Apply Button.

Final Thoughts

With Tableau, the "slicer" you are looking for is called a "filter," and mastering it is about more than just dragging and dropping a field. By customizing the layout, applying it strategically to multiple worksheets, and configuring advanced options like context filters, you can build truly insightful and professional-grade dashboards that your stakeholders will love to use.

Of course, becoming proficient in tools like Tableau takes time and patience - courses to learn the software can take dozens of hours. If you need powerful dashboards without the steep learning curve, you might find our tool helpful. We created Graphed to be your AI-powered data analyst. You can connect your marketing and sales data sources in seconds, then simply describe the report you need in plain English. Graphed builds a live, interactive dashboard for you, saving you a few hours of work every week jumping between platforms, wrangling spreadsheets, and building reports.