How to Create a Slicer in Tableau

If you're coming from Excel or Power BI, you're probably looking for a quick way to create a "slicer" in Tableau. The good news is that you can absolutely create the same interactive filtering experience, but Tableau calls it a "filter." This guide will walk you through exactly how to add, customize, and manage filters to make your dashboards dynamic and user-friendly.

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

First Things First: What is a "Slicer" in Tableau?

In tools like Microsoft Excel and Power BI, a slicer is a user-friendly button or panel that allows you to easily filter your data visualization, like a chart or a PivotTable. You click a button for 'East Region', and all your data updates instantly to show only results from that region.

Tableau achieves the exact same functionality using Filters. While the name is different, the result is the same: providing an interactive way for you or your audience to slice and dice the data on a worksheet or dashboard. Once you create a filter, you can display it as an interactive card that looks and feels just like the slicers you're used to - and in many ways, offers even more customization.

How to Add a Basic Filter to a Worksheet

Let's start by adding a simple filter to a single chart or "viz." For this example, imagine you have a bar chart showing sales by sub-category, and you want to be able to filter it by region.

Here are the step-by-step instructions:

1. Drag a Dimension to the Filters Shelf: In the Data pane on the left, find the dimension you want to use as your filter. In our case, this would be the Region dimension. Click and drag the Region pill directly onto the "Filters" shelf, which is located just above the Marks card.
2. Select Values in the Filter Dialog Box: Once you drop the pill onto the shelf, a dialog box will pop up. This box gives you several options for setting up your initial filter. The 'All' tab is the most common starting point. Here, you'll see a list of all the values within that dimension (e.g., Central, East, South, West). You can select the values you want to include by default. For now, you can click "All" and then "OK." We'll make it interactive in the next step.
3. Show the Filter Card: On the Filters shelf, you will now see the 'Region' pill. Right-click on this pill, and in the context menu that appears, select "Show Filter."

That's it! You will now see a small filter card appear on the right side of your worksheet. It will likely default to a checklist of the regions. You can now check and uncheck the boxes, and your visualization will update in real time. You’ve just created your first Tableau slicer.

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

Customizing Your Tableau Filter to Behave Like a Slicer

The real power of Tableau’s filters comes from their flexibility. You can change how the filter card looks and functions to match your dashboard's needs. This is where you transform a basic filter into a fully-featured slicer.

To access the customization options, click the small dropdown arrow (▼) at the top-right corner of the filter card that you just created. You'll see a list of different display types. Let's break down the most common ones.

1. Single-Value Filters

Use these when you only want the user to be able to select one option at a time. This is useful for slicing data by things like 'Current Month' vs. 'Previous Month' where a multi-select wouldn't make sense.

• Single Value (List): This displays the options as radio buttons. It's clear and intuitive, making it great for when there are only a few choices (e.g., 2-5 options). It's very easy for a user to understand they can only pick one.
• Single Value (Dropdown): This is a more compact version that hides the options within a dropdown menu. It's an excellent space-saver on a busy dashboard, especially if the list of options is long.
• Single Value (Slider): Best suited for ordered dimensions like dates or quantitative bins. For example, you could let a user slide through individual months or years to see how the data changes sequentially.

2. Multiple-Value Filters

These are the closest equivalent to a traditional slicer, allowing users to select one or more items to view.

• Multiple Values (List): This is the default setting and arguably the most common format. It displays all options as a list of checkboxes. Users can select any combination of values. This is perfect for dimensions like 'Product Category' or 'Country'.
• Multiple Values (Dropdown): Like its single-value counterpart, this bundles the checkbox list inside a dropdown menu. It's a lifesaver when you need to offer multi-select filtering for a dimension with dozens of values (like 'State' or 'City') without cluttering your dashboard.
• Multiple Values (Custom List): This option allows users to type in the values they want to see, separated by commas. It's less common but useful for power users who know exactly what they're looking for.
• Wildcard Match: This presents a text box where a user can type a partial match to filter the list. For example, they could type "Chairs" to see data for "Office Chairs," "Armchairs," and "Folding Chairs." It supports patterns like "contains," "starts with," "ends with," and "exact match."

Pro-Tip: Remove the 'All' Option

By default, many filter cards include an "(All)" option at the top. Sometimes this is useful, but other times you might want users to make a conscious selection. To remove it, click the filter card's dropdown menu and navigate to "Customize." In the options that appear, simply uncheck the "Show 'All' Value" 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

Applying Your "Slicer" to an Entire Dashboard

A slicer's main purpose is to control an entire dashboard, not just one chart. Having a single 'Region' filter that updates your sales map, an orders trendline, and a profit bar chart simultaneously is how dashboards become powerful analytical tools.

Once you've constructed a dashboard by pulling several worksheets onto it, here's how to make one filter control them all:

1. Show the Filter on the Dashboard: Once your charts are on the dashboard, pick one whose filter you want to use. Click on that worksheet within the dashboard to select it. Then, click the small dropdown arrow at the top-right corner of that worksheet's border and navigate to Filters > [Your Filter Name]. For our example, this would be Filters > Region.
2. Specify which Worksheets to Apply the Filter to: The interactive filter card for 'Region' will now appear on your dashboard. Click the dropdown arrow on this filter card.
3. Hover over "Apply to Worksheets" and you will see several choices:

Once you've made your selection, your slicer is now fully functional. Clicking a region will update every connected sheet on the dashboard at the same time.

Advanced Filtering Techniques for More Dynamic Dashboards

Ready to go beyond the basics? These techniques will let you build smarter, more responsive "slicers."

Cascading Filters (Only Relevant Values)

A cascading filter is when your choice in one filter limits the choices available in another. For example, a user selects a value in the 'Region' filter, and a second 'State' filter automatically updates to show only the states within that selected region.

To set this up:

1. Add both filters to your dashboard (e.g., 'Region' and 'State').
2. On the second filter ('State' in this case), click its dropdown menu.
3. Select the option "Only Relevant Values."
4. That's it! Now, when a user selects "West" in the 'Region' filter, the 'State' filter list will shrink from all 50 states to just California, Oregon, Washington, etc. This creates a much cleaner and more logical user experience.

Context Filters

Normally, all filters in Tableau are evaluated independently against your full data source. But what if you have a massive dataset and you want Tableau to perform a major, high-level filter first before bothering with the rest? This is where a context filter comes in.

When you designate a filter as a "context filter," you are telling Tableau to create a temporary, smaller subset of your data based on that filter's selection. All other filters on the sheet will then run only against that pre-filtered temporary table.

Why is this useful?

• Performance: On datasets with millions of rows, adding a dimension like 'Year' to the context significantly speeds up all other subsequent filters because they are now operating on a much smaller dataset.
• Controlling Top N Filters: If you use a "Top 10" filter (e.g., show Top 10 Products by Sales), a regular dimension filter is applied after Tableau has already identified the top 10 products overall. So, filtering by a specific product category might show you fewer than 10 products, or none at all. By making the category filter a context filter, you force Tableau to first filter to that category and then find the top 10 products within it.

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

How to create one:

On the Filters shelf, right-click the pill of the filter you want to elevate and select "Add to Context." The pill on the shelf will turn grey, indicating it's now a context filter.

Final Thoughts

Creating interactive filters, or "slicers," is a fundamental skill for building useful and engaging Tableau dashboards. By understanding how to add filters, customize their appearance, apply them across multiple sheets, and use advanced options like cascading and context filters, you can transform static reports into powerful, self-service analytical tools that empower users to find their own answers.

We believe that tools like Tableau are fantastic for deep data exploration and building comprehensive dashboards. But sometimes, you need answers more immediately without getting caught up in building views, dragging pills, or even setting up slicers. With Graphed, we address this in a different way by letting you connect your data sources - like Google Analytics, Shopify, or Salesforce - and then simply ask questions or describe the dashboard you want in plain English. Your filter becomes a question like, "Show me product sales for the West region last quarter." It’s designed to eliminate the manual setup and get insights in seconds, helping you and your team make faster, data-driven decisions.