Filters are the backbone of every interactive dashboard. Knowing the correct filter type — and understanding the order Tableau processes them — is the difference between dashboards that work correctly and dashboards that produce subtly wrong numbers. This lesson gives you complete command of every filter type plus every sorting technique in Tableau's toolkit.
Module 7 of 25+ · Phase 2 Progress32%
🔢 Section 1
The Filter Order of Operations
Tableau processes filters in a specific sequence. Understanding this order is critical — it determines what data each filter type "sees" and directly affects your dashboard's accuracy. Many analytical bugs come from using the wrong filter type at the wrong stage.
1
Extract Filters
Applied when creating a .hyper extract. Permanently removes rows from the extract file — they don't exist at all for any downstream filter.
2
Data Source Filters
Applied before any worksheet sees the data. Affects all worksheets using this data source. Set on the Data Source page.
3
Context Filters
Creates a temporary data subset. All subsequent filters (including Top N) run against this reduced dataset — not the full data.
4
Dimension Filters
Regular filters on categorical fields in the Filters shelf. Most common filter type. Runs after context filters.
5
Measure Filters
Filters on aggregated numeric fields (SUM, AVG, etc.). Runs last — operates on the aggregated results, not individual rows.
⚠️
The Top N + Context Filter Problem
This is one of the most common Tableau bugs. You create a Top 10 Products filter by Sales, plus a Region Quick Filter. Without a Context Filter, the Top 10 is computed across ALL regions, then the Region filter removes some of those products — you may end up with fewer than 10 results! The fix: right-click the Region filter pill in the Filters shelf → Add to Context. Now Tableau first filters by region, then computes Top 10 within that region. Always add dimensional filters that should "scope" a Top N to the context.
⚡ Section 2
Context Filters
A Context Filter creates a temporary isolated dataset that all other filters (and table calculations) run against. It's the most misunderstood filter type in Tableau, yet it solves several common problems elegantly.
What Context Filters Solve
Without a context filter, Tableau applies all dimension filters independently against the full dataset. This causes two problems: (1) Top N filters count across the full data before dimension filters remove rows, and (2) table calculations run across the full dataset before dimension filters apply, producing wrong percentages.
How to Add a Context Filter
1
Add the Scoping Filter First
Drag the dimension that should "scope" your analysis to the Filters shelf (e.g., Region). Configure its filter condition normally.
2
Right-Click → Add to Context
Right-click the Region filter pill in the Filters shelf → Add to Context. The pill turns grey (instead of blue) to indicate it's now a Context filter. Tableau immediately re-queries with this as the base dataset.
3
Add Top N or Table Calc
Now add your Top N filter or table calculation. It runs against the context-filtered dataset (e.g., only the selected region) instead of all data.
Performance Consideration
Context filters cause Tableau to create a temporary table in the database (for live connections) or create a temp in-memory dataset (for extracts). Each time a user changes the context filter selection, Tableau rebuilds this temp table. For very large datasets, this can slow dashboard interactivity. Use context filters when necessary for correctness, but avoid them as a general optimization strategy.
🎛️ Section 3
Quick Filters — Dashboard Interactivity
Quick Filters (also called Filter Controls or Show Filters) are the interactive UI elements that let dashboard viewers filter data themselves — dropdown lists, sliders, date range pickers, and checkboxes. They turn a static chart into an interactive analytical tool.
Adding a Quick Filter
1
Show the Filter Control
Option A: Right-click a filter pill in the Filters shelf → Show Filter. Option B: Right-click any field in the Data pane → Show Filter. A filter control card appears on the worksheet (or dashboard).
2
Choose the Control Type
Click the dropdown arrow on the filter control card to change its type. For dimensions: Single Value (List), Single Value (Dropdown), Multiple Values (List), Multiple Values (Dropdown), Wildcard Match. For dates: Date Range, Relative Date. For measures: Range of Values, At Least, At Most.
3
Apply to Multiple Worksheets
On a dashboard, right-click the filter control → Apply to Worksheets → All Using This Data Source (or select specific sheets). This makes one filter control update multiple charts simultaneously.
Quick Filter Best Practices
Scenario
Recommended Type
Why
Pick exactly one option at a time
Single Value (Dropdown)
Saves space, prevents multi-selection confusion
Compare multiple options at once
Multiple Values (Checkbox List)
Lets users toggle individual items on/off
Filter by date period
Relative Date
Users can pick "Last 30 days", "This quarter", etc. dynamically
Filter on a numeric range (Sales > X)
Range of Values (Slider)
Intuitive visual slider for continuous ranges
Search for a specific customer/product
Wildcard Match
Type-to-search within the dimension's values
🔝 Section 4
Top N Filters
Top N filters let you show only the highest or lowest N items in a view — Top 10 Products, Bottom 5 Regions, Top 20 Customers by Revenue. Tableau's Top N filter has two modes: static (fixed number) and dynamic (using a parameter).
Creating a Static Top N Filter
1
Drag Dimension to Filters Shelf
Drag Product Name (or any dimension) to the Filters shelf. The filter dialog opens.
2
Select the "Top" Tab
In the filter dialog, click the Top tab. Select "By Field". Choose "Top" or "Bottom". Set the number (e.g., 10). Select the measure to rank by (SUM of Sales). Click OK.
3
Verify the Context Filter
If you have other dimension filters (Region, Category), add them to context first (right-click → Add to Context) to ensure the Top N is computed within the filtered scope.
Dynamic Top N with a Parameter
A Parameter is a user-controlled variable. Instead of a fixed "Top 10", you can let dashboard users choose the N themselves. Create a parameter: right-click in the Data pane → Create Parameter → name it "Top N" → set Data Type to Integer → Range 1 to 50, step 1. Then in your Top N filter, instead of a fixed number, select "Top N" parameter. Add the parameter control to the dashboard (right-click the parameter → Show Parameter). Now users can drag a slider or enter a number to change the Top N dynamically.
💡
Parameters vs Filters — Key Difference
Quick Filters are restricted to existing values in the data — you can only filter to values that exist in the field. Parameters are free-form inputs that can take any value you define — integers, decimals, strings, dates. Use parameters when you want users to input a custom threshold, a target value, a date range boundary, or a dynamic N for Top N charts. Parameters are a gateway to a whole category of highly interactive Tableau features covered in Phase 3.
🔃 Section 5
Sorting Methods
Sorted data communicates faster. A bar chart sorted descending communicates rank instantly — the audience doesn't have to scan left and right to find the highest value. Tableau offers multiple sorting methods for different situations.
Toolbar Sort
Click the Sort Ascending (↑) or Sort Descending (↓) icon in the toolbar while the chart is selected. Quick one-click sort — sorts the left-most dimension by the primary measure.
Axis Sort
Click directly on an axis label to toggle sort order. A small sort indicator icon (▲▼) appears on the axis. Click again to reverse. Right-click for more sort options.
Field Sort (Dialog)
Right-click any dimension pill on Rows/Columns → Sort → Field. Choose a measure and aggregation (SUM, AVG) to sort by. This is the persistent, reliable sort — it survives filter changes.
Manual Sort
Drag individual labels in the view to reorder them manually. Use when the logical order isn't alphabetical or by measure (e.g., traffic light order: Red, Yellow, Green).
Computed Sort
Sort by any computed field, including calculated fields. Right-click the dimension pill → Sort → Field → select your calculated KPI as the sort measure.
Nested Sort
When you have multiple dimensions on a shelf (e.g., Region + Category), right-click the innermost dimension → Sort → Field. This sorts sub-categories within each parent group independently.
💡
Persistent vs Temporary Sorts
Toolbar and axis click sorts are temporary — they can be overridden by Tableau's default sorting when data is refreshed or filters change. Field Sort via the right-click dialog is persistent — it's saved with the workbook and re-applied every time the view is rendered. For production dashboards, always use persistent Field Sort to ensure consistent presentation across all filter states.
Nested Sort — Sorting Within Groups
Nested sorts let each sub-group be sorted independently. If you have Region → Category on Rows, a nested sort on Category means the category order can differ within each Region — the highest-selling category appears first regardless of which region you're looking at. Without nested sort, all regions would show categories in the same order, which might be misleading if East sells Technology most but West sells Furniture most.
🔑 Key Concepts — Lesson 7
Filter Order
Extract → Data Source → Context → Dimension → Measure. The sequence determines what data each filter type sees and affects.
Context Filter
Creates a temporary data subset. All subsequent filters run against this reduced dataset. Essential for correct Top N behavior with other active filters.
Quick Filter
An interactive UI control (dropdown, slider, checkbox) that lets dashboard users filter data. Can be applied to one or all worksheets using the same data source.
Top N Filter
Shows only the highest or lowest N members of a dimension, ranked by a measure. Can be static (fixed N) or dynamic (driven by a parameter).
Parameter
A user-controlled variable that can hold any value. Used to drive dynamic Top N, date ranges, thresholds, and conditional calculations in views.
Nested Sort
Sorts sub-dimension members independently within each parent group. Ensures each group is ranked correctly by its own local values.
🧠 Knowledge Check
1. In Tableau's filter order of operations, which filter type runs FIRST — before all others?
2. You have a Top 10 Products filter AND a Region filter. When you select "West" region, you only see 7 products instead of 10. What is the most likely fix?
3. A user wants to search for a specific product by typing part of its name in a Quick Filter. Which Quick Filter type should you use?
4. What is the key visual indicator that a filter pill has been converted to a Context Filter in Tableau?
5. Which sorting method is "persistent" and survives filter changes and data refreshes in a Tableau dashboard?
🏆
✅ Lesson Summary
What You Learned
📋
Lesson 7 — Key Takeaways
✅ Filter order: Extract → Data Source → Context → Dimension → Measure
✅ Context filters create a temporary dataset — essential for correct Top N behavior
✅ Grey pill = Context filter · Context filters trigger temp table creation (performance cost)
✅ Quick Filters: Dropdown, Checkbox, Wildcard Match, Range Slider, Relative Date
✅ Dynamic Top N: use a Parameter to let users choose N interactively
✅ Persistent sort: right-click pill → Sort → Field (survives refreshes and filter changes)
You now have complete command of Tableau's filtering system and sorting methods. Next: Groups, Sets, and Hierarchies — powerful tools for organizing and segmenting your dimensions in ways that unlock new analytical perspectives.