How to Add a Filter in Tableau Worksheet

Taming a large dataset starts with learning how to filter it effectively. In Tableau, filters are the secret to transforming seas of raw data into focused, actionable insights for you and your audience. This guide walks you through the fundamentals of adding, customizing, and applying different types of filters to your Tableau worksheets.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Filters are Essential in Tableau

At a basic level, filters let you include or exclude data from your view. They are the primary tool for narrowing the scope of your analysis to focus on what matters most. Instead of looking at global sales data for the last five years, you can use filters to drill down into sales for a specific product category in the last quarter, for a single region.

More importantly, filters are what make your dashboards interactive. By exposing a filter as a user-facing control, you empower your audience to explore the data for themselves. They can slice and dice the information, ask their own questions, and uncover insights relevant to their specific needs without having to edit the underlying worksheet.

Your Control Center: The Filters Shelf

Before adding any filters, it's important to know where they live. In a Tableau worksheet, you’ll find the Filters shelf located just above the Marks card and below the Columns and Rows shelves. Any field (or "pill" as Tableau calls them) you want to use for filtering must be dragged onto this shelf. This shelf acts as your control panel for all the active filters on a particular worksheet, allowing you to see at a glance what data is being included or excluded.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Add a Basic Dimension Filter (Step-by-Step)

Dimensions are categorical fields in your data - think things like Product Category, Country, or Customer Name. Filtering by a dimension is one of the most common tasks in Tableau. Let’s walk through an example using a hypothetical sales dataset.

Our goal: Create a bar chart showing sales by Sub-Category, but only for the Consumer and Corporate segments.

Step 1: Build Your Initial View

First, create the basic visualization. Drag the Sales measure to the Columns shelf and the Sub-Category dimension to the Rows shelf. You should now see a simple horizontal bar chart showing sales for all sub-categories across all segments.

Step 2: Add the Dimension to the Filters Shelf

Find the dimension you want to filter by - in this case, Segment - in the Data pane on the left. Click and drag the Segment pill onto the Filters shelf.

Step 3: Configure the Filter

As soon as you drop the pill, a dialog box will appear. This window gives you several ways to configure your filter.

On the General tab, you'll see a list of all available members in that dimension: Consumer, Corporate, and Home Office.

• Check the boxes next to Consumer and Corporate to include them.
• Alternatively, you could check Home Office and then tick the Exclude box at the bottom. This would exclude Home Office and include everything else - a useful shortcut for fields with many members.

Click OK.

Just like that, your worksheet updates! The bar chart now shows sales by sub-category for only the Consumer and Corporate segments. You'll see the Segment pill on your Filters shelf, clearly indicating that a filter is active.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Making Your Filter Interactive

The filter is working, but it’s currently only visible to you, the creator. To let your audience use it, you need to show it on the worksheet.

1. Go to the Filters shelf and right-click on your Segment pill.
2. Select Show Filter from the context menu.

A filter control card, often called a quick filter, will appear on the right side of your view. By default, it might be a list of checkboxes. You can customize its appearance by clicking the small dropdown arrow on the card. For the Segment field, cleaner options might be:

• Single Value (list): Users can only select one segment at a time using radio buttons.
• Single Value (dropdown): A compact dropdown for selecting one segment.
• Multiple Values (dropdown): A good option for saving space when you have many choices.

How to Filter with Measures

Filtering by measures allows you to focus on a quantitative range. For example, you might want to see only the products with sales over $10,000 or deals with a profit margin between 10% and 20%.

Let's filter our view to show only the sub-categories whose total sales are greater than $200,000.

1. From the Data pane, drag the Sales measure to the Filters shelf.
2. Tableau will ask how you want to aggregate the measure for filtering. Since our view shows the sum of sales for each sub-category, Sum is the correct choice. Click Next.
3. A new window appears where you can set the range. You can use the slider, or for more precision, type directly into the boxes. Select At Least and enter 200000.
4. Click OK.

Your chart will immediately update, filtering out any sub-categories that didn't meet the SUM(Sales) > $200,000 criteria. You can also show this filter to the end-user, often as a slider, allowing them to dynamically adjust the sales threshold.

Working with Date Filters

Date fields have special filtering options in Tableau that are incredibly useful for time-based analysis. When you drag a date field (like Order Date) to the Filters shelf, you’ll get a unique menu asking how you want to filter:

• Relative Date: This is a dynamic option that filters relative to today's date. You can choose from presets like "Previous Year," "Last 3 months," or "Year to Date." This is perfect for dashboards that need to always show the most current data without manual updates.
• Range of Dates: This lets you set a specific start and end date for your analysis. It's static, so it’s ideal for reports focused on a specific period, like Q4 2023.
• Discrete Date Parts: You can also choose to filter by selecting specific years, quarters, months, or weekdays (e.g., show data only for 2022 and 2024, or only for weekdays).

Graphed

Still Building Reports Manually?

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

Watch the Demo

An Important Concept: Context Filters

As you build more complex views, you’ll encounter situations where the order in which filters are applied matters. This is where Context Filters become important.

Imagine a new requirement: "From the Consumer segment, show me the top 5 performing Sub-Categories by Sales."

Our instinct might be to add two filters:

1. A dimension filter for Segment = "Consumer"
2. A "Top N" filter on Sub-Category (Right-click Sub-Category > Filter > Top tab > By field: Top 5 by Sales)

By default, Tableau evaluates these two filters independently. It first finds the global Top 5 sub-categories across all segments, and then applies the segment filter. This might not give you what you want - it just tells you which of the overall top performers happen to be in the Consumer segment.

To fix this, you need to tell Tableau to apply the Segment filter first. You do this by adding it to context.

1. On the Filters shelf, right-click the Segment pill.
2. Select Add to Context.

The pill on the shelf will turn gray. Now, Tableau will filter for the "Consumer" segment before running the Top 5 calculation. The view correctly shows the Top 5 Sub-Categories purely within the consumer context.

Tips for Efficient Filtering

• Apply Filters to Multiple Worksheets: If a filter should apply to an entire dashboard, you don't need to add it to every sheet. Add it to one, then right-click its pill on the Filters shelf and go to Apply to Worksheets > Selected Worksheets.... This creates a single, global filter control.
• Use "Only Relevant Values": When you have cascading filters (like Region and State), they can be frustrating if they're not connected. Use the "Only Relevant Values" option on the second filter's card. This way, when a user selects "West" in the Region filter, the State filter will automatically update to show only states in the West.
• Keep Performance in Mind: Every filter adds a query instruction. On massive datasets, numerous complex filters, especially context filters, can slow down your dashboard. Keep your filter set as simple as possible to deliver a snappy user experience.

Final Thoughts

Mastering filters is foundational to becoming proficient in Tableau. They are your primary tool for moving from high-level overviews to granular details, providing clarity and focus to your analysis. By understanding the differences between dimension, measure, date, and context filters, you can build powerful, interactive, and user-friendly dashboards.

Building dashboards in tools like Tableau is incredibly powerful but involves many manual steps to connect data, set up visualizations, and configure filters. At Graphed, we’ve simplified this process by enabling you to build real-time reports and dashboards across all your marketing and sales platforms just by using plain English. Instead of clicking through menus and dragging pills, just ask for what you need - like, "Show me my top 5 product categories by sales in the consumer segment for last quarter" - and watch as the dashboard builds itself in seconds.