Context filters in Tableau - Dashboard Guide

Dashboard Mode - Context filters

Business Question

How do we analyze sales performance for top product categories in selected regions using context filters to improve dashboard speed and accuracy?

Sample Data

Order ID	Region	Category	Sales	Profit
1001	East	Furniture	500	50
1002	West	Technology	1200	300
1003	East	Office Supplies	300	30
1004	South	Furniture	700	70
1005	West	Office Supplies	400	40
1006	East	Technology	1500	350
1007	South	Technology	800	200

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 5400
• KPI Card: Total Profit
  Formula: SUM([Profit])
  Result: 1040
• Bar Chart: Sales by Category
  Formula: SUM([Sales]) grouped by [Category]
  Results:
  - Furniture: 1200
  - Technology: 3500
  - Office Supplies: 700
• Context Filter: Region
  Applied first to limit data to selected regions (e.g., East and West)
  This filter sets the context for all other filters and calculations.
• Regular Filter: Category
  Applied after context filter to select top categories by sales.

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |     Total Profit      |
|      (KPI Card)       |      (KPI Card)       |
+----------------------+----------------------+
|                                              |
|           Sales by Category (Bar Chart)      |
|                                              |
+----------------------------------------------+
| Context Filter: Region | Regular Filter: Category |
+-----------------------+-------------------------+
    

Interactivity

The Context Filter on Region is applied first. It limits the data to only the selected regions, for example, East and West. This reduces the data volume and speeds up the dashboard.

After the context filter, the Regular Filter on Category selects the top product categories based on sales within the filtered regions.

All KPI cards and the bar chart update dynamically based on these filters. Changing the Region context filter recalculates all components quickly because it sets the data scope first.

Self Check

If you add a context filter to select only the East region, which components update and how?

• The Total Sales KPI updates to sum sales only from East region: 500 + 300 + 1500 = 2300.
• The Total Profit KPI updates to sum profit only from East region: 50 + 30 + 350 = 430.
• The Sales by Category bar chart updates to show sales for East region categories only:
• Furniture: 500
• Office Supplies: 300
• Technology: 1500
• The regular category filter applies after the context filter, so it filters categories within East region data.

Key Result

Dashboard shows total sales, total profit, and sales by category filtered by region using context filters for faster, accurate analysis.