Parameter controls 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 year to see sales data for that year only.

📊 Data: You have monthly sales data for multiple years including columns: Year, Month, Region, and Sales Amount.

🎯 Deliverable: Create a Tableau dashboard with a parameter control that lets users pick a year, and the sales chart updates to show monthly sales for the selected year.

Sample Data

Year	Month	Region	Sales Amount
2021	January	North	5000
2021	February	North	4500
2021	January	South	7000
2021	February	South	6500
2022	January	North	5200
2022	February	North	4800
2022	January	South	7200
2022	February	South	6800

1

Step 1: Connect to the sales data source in Tableau and load the data.

No formula needed; just connect and load data.

Expected Result

Sales data with Year, Month, Region, and Sales Amount is available in Tableau.

2

Step 2: Create a parameter named 'Select Year' with data type Integer and list of values 2021 and 2022.

Parameter configuration: Name='Select Year', Data type='Integer', Allowable values='List', List values=[2021, 2022], Current value=2021.

Expected Result

Parameter 'Select Year' appears in Tableau with options 2021 and 2022.

3

Step 3: Create a calculated field named 'Filtered Sales' that shows sales only for the selected year.

IF [Year] = [Select Year] THEN [Sales Amount] ELSE NULL END

Expected Result

Calculated field 'Filtered Sales' returns sales amount only for the year chosen in the parameter.

4

Step 4: Build a line chart with Month on Columns and sum of 'Filtered Sales' on Rows.

Columns: [Month], Rows: SUM([Filtered Sales])

Expected Result

Line chart shows monthly sales for the selected year only.

5

Step 5: Add the 'Select Year' parameter control to the dashboard for user interaction.

Right-click 'Select Year' parameter > Show Parameter Control.

Expected Result

Dashboard has a dropdown allowing users to pick 2021 or 2022, updating the chart accordingly.

Final Result

Monthly Sales Trend for Selected Year

Select Year: [2021 ▼]

Month | Sales
----------------
Jan   | ***** (5000)
Feb   | ****  (4500)
Mar   |       (0)
...

When user changes year to 2022, sales bars update to show 2022 values.

✓Sales vary month to month within each year.

✓Parameter control allows quick comparison of sales trends between years.

✓Interactive dashboard helps managers focus on one year at a time.

Bonus Challenge

Add a second parameter to select Region (North or South) and update the chart to filter by both year and region.

Show Hint

Create a 'Select Region' parameter with values 'North' and 'South'. Modify the calculated field to check both [Year] = [Select Year] and [Region] = [Select Region].