Filter actions in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants an interactive dashboard where clicking on a region filters the sales data to show only that region's details.

📊 Data: You have monthly sales data by Region, Product Category, and Sales Amount.

🎯 Deliverable: Create a Tableau dashboard with a map of regions and a sales table. Set up a filter action so clicking a region on the map filters the sales table to that region.

Sample Data

Region	Month	Product Category	Sales Amount
North	Jan	Electronics	12000
North	Feb	Furniture	8000
South	Jan	Electronics	15000
South	Feb	Furniture	7000
East	Jan	Electronics	10000
East	Feb	Furniture	6000
West	Jan	Electronics	9000
West	Feb	Furniture	5000

1

Step 1: Connect to the sales data in Tableau and create a new worksheet named 'Region Map'.

Drag 'Region' to Rows and Columns to create a map or use filled map mark type with 'Region' as geographic role.

Expected Result

A map showing the four regions: North, South, East, and West.

2

Step 2: Create a new worksheet named 'Sales Table' to show detailed sales data.

Drag 'Region', 'Month', 'Product Category' to Rows and 'Sales Amount' to Text or Columns with SUM aggregation.

Expected Result

A table showing sales amounts by Region, Month, and Product Category.

3

Step 3: Create a new dashboard and add both 'Region Map' and 'Sales Table' worksheets.

Drag both worksheets onto the dashboard canvas side by side.

Expected Result

Dashboard displays the map and the sales table.

4

Step 4: Add a filter action to the dashboard to link the map and the sales table.

In Dashboard menu, select Actions > Add Action > Filter. Set source sheet to 'Region Map', target sheet to 'Sales Table'. Set run action on 'Select'. Target filters: 'Selected Fields' with 'Region'.

Expected Result

Clicking a region on the map filters the sales table to show only that region's sales.

5

Step 5: Test the filter action by clicking on different regions on the map.

Click 'North' on the map and observe the sales table.

Expected Result

Sales table updates to show only sales data for the North region.

Final Result

Dashboard Layout:
+----------------+  +---------------------+
|  Region Map    |  |    Sales Table       |
|  [Map of four  |  |  Region | Month |    |
|   regions]     |  |  Product Category |   |
|                |  |  Sales Amount      |   |
+----------------+  +---------------------+

Interaction:
Click a region on the map -> Sales Table filters to that region

✓Filter actions allow interactive exploration of data by linking visualizations.

✓Clicking a region on the map dynamically filters the sales table to show relevant data.

✓This improves dashboard usability and helps managers focus on specific regions quickly.

Bonus Challenge

Add a second filter action so that clicking a product category in the sales table filters the map to highlight only regions with sales in that category.

Show Hint

Create a filter action with source sheet 'Sales Table' and target sheet 'Region Map', filtering on 'Region' based on selected 'Product Category'.

Practice

1. What is the main purpose of a Filter Action in Tableau dashboards?

easy

A. To make dashboards interactive by linking charts through clicks or hovers

B. To change the color scheme of the dashboard

C. To export data from Tableau to Excel

D. To create calculated fields automatically

Solution

1. Step 1: Understand what filter actions do

   Filter actions allow users to click or hover on one chart to filter data in another chart, making dashboards interactive.

2. Step 2: Eliminate unrelated options

   Changing colors, exporting data, or creating calculated fields are not related to filter actions.

3. Final Answer:

   To make dashboards interactive by linking charts through clicks or hovers -> Option A

4. Quick Check:

   Filter actions = interactive linking [OK]

Hint: Filter actions connect charts by clicks or hovers [OK]

Common Mistakes:

• Confusing filter actions with formatting options
• Thinking filter actions export data
• Assuming filter actions create calculations

2. Which of the following is the correct way to set up a filter action in Tableau?

easy

A. Create a calculated field and drag it to the filter shelf

B. Select source sheet, target sheet, and define filter behavior

C. Use the Data menu to export filtered data

D. Change the dashboard size to enable filtering

Solution

1. Step 1: Identify filter action setup steps

   Setting up a filter action requires choosing the source sheet (where user clicks), the target sheet (which gets filtered), and how the filter applies.

2. Step 2: Remove unrelated options

   Creating calculated fields, exporting data, or changing dashboard size are not steps to set up filter actions.

3. Final Answer:

   Select source sheet, target sheet, and define filter behavior -> Option B

4. Quick Check:

   Filter action setup = source + target + filter behavior [OK]

Hint: Filter actions need source and target sheets defined [OK]

Common Mistakes:

• Confusing filter actions with calculated fields
• Trying to export data to filter
• Thinking dashboard size controls filtering

3. Given a dashboard with a filter action set from Sheet A to Sheet B on the field Category, what happens when a user clicks on 'Furniture' in Sheet A?

medium

A. Sheet A filters out 'Furniture' category

B. Sheet B shows all categories except 'Furniture'

C. Sheet B shows data only for 'Furniture' category

D. Sheet B does not change

Solution

1. Step 1: Understand filter action behavior

   Clicking 'Furniture' in Sheet A sends a filter to Sheet B to show only 'Furniture' data.

2. Step 2: Eliminate incorrect outcomes

   Sheet B will not exclude 'Furniture' or remain unchanged; Sheet A does not filter itself.

3. Final Answer:

   Sheet B shows data only for 'Furniture' category -> Option C

4. Quick Check:

   Click filters target sheet to clicked value [OK]

Hint: Click filters target sheet to clicked value [OK]

Common Mistakes:

• Thinking filter excludes clicked value
• Assuming source sheet filters itself
• Believing target sheet remains unchanged

4. You set a filter action from Sheet X to Sheet Y, but clicking on Sheet X does not filter Sheet Y. What is the most likely cause?

medium

A. Filter actions only work on hover, not click

B. The dashboard size is too small

C. Sheet Y has no data

D. Source and target sheets are not correctly assigned in the filter action

Solution

1. Step 1: Check filter action configuration

   If clicking Sheet X does not filter Sheet Y, the source and target sheets may be incorrectly set or reversed.

2. Step 2: Exclude unrelated reasons

   Dashboard size does not affect filter actions; Sheet Y having no data would show empty but still respond; filter actions can work on click or hover depending on settings.

3. Final Answer:

   Source and target sheets are not correctly assigned in the filter action -> Option D

4. Quick Check:

   Correct source and target sheets enable filtering [OK]

Hint: Verify source and target sheets in filter action setup [OK]

Common Mistakes:

• Ignoring source-target assignment
• Blaming dashboard size
• Assuming filter actions only work on hover

5. You want to create a dashboard where clicking on a region in a map filters multiple charts by that region, but hovering over the map filters only one chart. How should you configure filter actions?

hard

A. Create two filter actions: one on click targeting multiple charts, one on hover targeting one chart

B. Create one filter action on click targeting all charts

C. Create one filter action on hover targeting all charts

D. Use a parameter instead of filter actions

Solution

1. Step 1: Understand different interaction types

   Click and hover are separate triggers for filter actions in Tableau.

2. Step 2: Configure multiple filter actions

   To have click filter multiple charts and hover filter only one chart, create two filter actions with different triggers and targets.

3. Step 3: Exclude incorrect options

   One filter action cannot have two triggers; parameters do not provide this interactive filtering behavior.

4. Final Answer:

   Create two filter actions: one on click targeting multiple charts, one on hover targeting one chart -> Option A

5. Quick Check:

   Separate filter actions for click and hover [OK]

Hint: Use separate filter actions for click and hover [OK]

Common Mistakes:

• Trying to use one filter action for both triggers
• Using parameters instead of filter actions
• Assuming hover can filter multiple charts differently