Quick Filters

A quick filter is an interactive control card that sits on a worksheet or dashboard and lets viewers filter the data themselves — without editing the workbook. Dropdown lists, sliders, checkboxes, and search boxes all appear as quick filter card types in Tableau.

Showing a Filter as an Interactive Control

Any filter on the Filters shelf can be surfaced as an interactive control card. The card appears on the right side of the worksheet (or anywhere on a dashboard) and lets the viewer select, deselect, or slide through values without Tableau Desktop access. This turns a static chart into an explorable view.

Drag a field — for example Region — to the Filters shelf. In the filter dialog, select all values and click OK. The filter is now active on the shelf but not yet visible to viewers.

Right-click the Region filter pill on the Filters shelf and select Show Filter. A filter card appears on the right side of the worksheet showing all four Regions with checkboxes. The viewer can now click to include or exclude any Region.

To change the control type, click the small dropdown arrow at the top-right of the filter card and choose a different card style from the list. The style options available depend on the field type — Dimension fields offer list-based controls, Measure fields offer sliders.

Quick Filter Card Types

Card Type	Field Type	Best Used When
Single Value (List)	Dimension	Viewer selects exactly one value at a time — radio button style
Single Value (Dropdown)	Dimension	Many values — dropdown saves space on the dashboard
Multiple Values (List)	Dimension	Viewer can check multiple values — checkbox style, default for most Dimensions
Multiple Values (Dropdown)	Dimension	Multi-select in a compact dropdown — good for long value lists
Multiple Values (Custom List)	Dimension	Viewer types values to search and add — best for high-cardinality fields like Customer Name
Wildcard Match	Dimension	Viewer types a text string — all matching values are included automatically
Range of Values	Measure or Date	Dual-handle slider — viewer drags min and max ends to define a range
Relative Date	Date	Last N days / weeks / months — always relative to today, ideal for operational dashboards

Filter Card — Labelled Mockup

Quick Filter Cards — Three common types side by side

Region

▼

(All)

Central East South West

Multiple Values (List)

Customising the Filter Card

Every filter card has a small dropdown arrow in its title bar that opens a customisation menu. The most useful options are:

Edit Title

Replace the field name with a plain-English label — "Filter by Region" instead of the raw field name "Region".

Only Relevant Values

Shows only the values that exist given the current state of other filters. Prevents viewers from selecting a combination that returns no data.

All Values in Database

Always shows every possible value regardless of other active filters. Allows cross-filter exploration — selecting a value that changes other filters to show relevant data.

Include / Exclude

Switches the filter card between Include mode (show only selected) and Exclude mode (hide selected, show all others). Right-click any value in the card to toggle.

Apply Button

Adds an Apply button to the card so the view only refreshes when the viewer clicks Apply — prevents slow queries on every single checkbox click for large data sources.

Relative Date Filters

Relative date filters are the most useful quick filter for operational dashboards because they update automatically based on today's date. A filter set to Last 30 Days will always show the most recent 30 days regardless of when the dashboard is opened — no manual date adjustment required.

To create one: drag Order Date to the Filters shelf → select Relative Date in the filter dialog → choose Days and set the period to Last 30. Show the filter as a card and set the card type to Relative Date — viewers can then adjust the period themselves (Last 7 days, Last quarter, Year to Date) without editing the workbook.

Applying a Quick Filter Across Sheets

A filter card on a worksheet controls only that worksheet by default. To make it control multiple worksheets from a dashboard, right-click the filter pill → Apply to Worksheets → All Using This Data Source. When the filter card is then placed on a dashboard, changing its value updates every connected worksheet simultaneously — a single Region selector controlling a bar chart, a map, and a trend line all at once.

📌 Teacher's Note

The card type choice matters more than most analysts realise. A Multiple Values List is the right default for a field with 4 to 8 values — viewers see all options at once and can check multiple. A Single Value Dropdown is correct for a field like Year where only one value should be active at a time. A Wildcard Match is the only sensible choice for high-cardinality fields like Customer Name or Product ID — showing 5,000 checkboxes in a list is unusable. The Only Relevant Values option is the single most important customisation on any multi-filter dashboard. Without it, a viewer can select a combination — say, Sub-Category = Tables and Region = South — and get an empty chart with no explanation. With Only Relevant Values active, the second filter automatically narrows to only the values that exist for the first filter's selection, preventing empty results entirely. Always enable it on dashboards with two or more interconnected filter cards.

Practice Questions

1. A Region filter is active on the Filters shelf but not visible to viewers. How do you surface it as an interactive control card on the worksheet?

2. A Customer Name field has 5,000 unique values. Which quick filter card type is most appropriate for this field?

3. A dashboard has two filter cards — Category and Sub-Category. Viewers keep selecting combinations that return empty charts. Which filter card setting prevents this?

Next up — Lesson 33: Parameters basics — creating dynamic inputs that let viewers control calculations, reference lines, and chart behaviour without editing the workbook.

← Previous Course Index Next →

Tableau Course