Parameter 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 sales dashboard where users can select a product category and see sales details update instantly.

📊 Data: You have sales data with columns: Order Date, Product Category, Product Name, Sales Amount, and Region.

🎯 Deliverable: Create a Tableau dashboard with a parameter action that lets users click on a product category to update sales details dynamically.

Sample Data

Order Date	Product Category	Product Name	Sales Amount	Region
2024-01-05	Electronics	Smartphone	500	North
2024-01-10	Electronics	Laptop	1200	South
2024-01-15	Furniture	Desk	300	East
2024-01-20	Furniture	Chair	150	West
2024-01-25	Clothing	T-Shirt	50	North
2024-01-30	Clothing	Jacket	200	South
2024-02-05	Electronics	Tablet	400	East
2024-02-10	Furniture	Sofa	800	West
2024-02-15	Clothing	Jeans	100	North
2024-02-20	Electronics	Headphones	150	South

1

Step 1: Connect your sales data to Tableau and create a worksheet showing total sales by Product Category.

Rows: Product Category; Columns: SUM(Sales Amount)

Expected Result

A bar chart with three bars: Electronics (2250), Furniture (1250), Clothing (350)

2

Step 2: Create a parameter named 'Selected Category' with data type String and allowable values from the list of Product Categories.

Parameter: Name='Selected Category', Data type=String, List: Electronics, Furniture, Clothing

Expected Result

A parameter that can hold one product category value at a time.

3

Step 3: Create a calculated field named 'Filter by Selected Category' that returns TRUE if Product Category equals the parameter value.

[Product Category] = [Selected Category]

Expected Result

Calculated field that filters data to only the selected category.

4

Step 4: Create a new worksheet showing detailed sales by Product Name and Region, filtered by the calculated field 'Filter by Selected Category'.

Filters: 'Filter by Selected Category' = TRUE; Rows: Product Name; Columns: Region; Text: SUM(Sales Amount)

Expected Result

Table showing sales details only for the selected product category.

5

Step 5: Add both worksheets to a dashboard.

Drag bar chart and detail table onto dashboard canvas.

Expected Result

Dashboard with sales by category bar chart and detailed sales table.

6

Step 6: Create a parameter action on the bar chart: when a user clicks a bar, update the 'Selected Category' parameter with that bar's Product Category.

Dashboard > Actions > Add Action > Change Parameter; Source Sheet: bar chart; Target Parameter: Selected Category; Field: Product Category

Expected Result

Clicking a bar updates the parameter and filters the detail table accordingly.

7

Step 7: Test the dashboard by clicking different product category bars and observe the detail table update instantly.

Interact with dashboard by clicking bars.

Expected Result

Detail table updates to show sales for the clicked product category.

Final Result

Electronics

↓

Clothing

✓Electronics is the highest sales category with $2250 total sales.

✓Furniture has strong sales mainly in West and East regions.

✓Clothing sales are lower but spread across multiple regions.

✓Parameter actions let users click categories to instantly filter details.

Bonus Challenge

Add a parameter action that lets users click on a region in the detail table to filter the bar chart to show sales only for that region.

Show Hint

Create a new parameter for Region and set up a parameter action on the detail table to update it. Then modify the bar chart to filter by the selected region parameter.