Parameter actions in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Parameter Actions Behavior

In Tableau, what happens when you use a parameter action to select a value on a dashboard?

Choose the correct description of the effect.

A The parameter action changes the data source connection to a different database.

B The parameter action filters the data source directly, removing unselected data from the dashboard.

C The parameter action creates a new calculated field that replaces the original data source.

D The parameter value updates dynamically based on the selected mark, affecting all views using that parameter.

💡 Hint

Think about what parameters do in Tableau and how parameter actions update their values.

Parameter actions allow users to change the value of a parameter by interacting with the dashboard. This updated parameter value can then be used in calculations or filters, affecting all views that reference it.

❓ dax_lod_result

intermediate

Parameter Action Impact on Calculated Field

Given a Tableau parameter named SelectedCategory with values: 'Furniture', 'Office Supplies', 'Technology'. A calculated field uses this parameter as:

IF [Category] = [SelectedCategory] THEN [Sales] ELSE 0 END

If the parameter action sets SelectedCategory to 'Technology', what is the sum of this calculated field for the data below?

Category       Sales
Furniture     100
Office Supplies 200
Technology    300
Technology    150

A 450

B 300

C 250

D 0

💡 Hint

Sum sales only where Category matches the parameter value.

The calculated field returns sales only for rows where Category equals 'Technology'. The sales for Technology are 300 + 150 = 450.

❓ visualization

advanced

Designing a Dashboard with Parameter Actions

You want to create a dashboard where clicking on a bar chart updates a map to show sales for the selected region using a parameter action. Which setup is correct?

A Create a filter action on the bar chart that filters the map directly by Region, no parameter needed.

B Create a parameter for Region, set a parameter action on the bar chart to update this parameter, then use the parameter in a filter on the map view.

C Create a calculated field that hardcodes the region, then use a parameter action to update the map data source connection.

D Use a parameter action to change the color palette of the map based on the selected bar.

💡 Hint

Parameter actions update parameters, which can be used in calculations or filters.

Parameter actions update the parameter value based on user interaction. The parameter can then be used in a filter or calculation to update the map view accordingly.

🔧 Formula Fix

advanced

Troubleshooting Parameter Action Not Updating

You created a parameter action to update a parameter when clicking a mark, but the parameter value does not change. Which is the most likely cause?

A The parameter is set to allow multiple values instead of a single value.

B The data source is missing a join between tables.

C The parameter action is not assigned to the correct source sheet or target parameter.

D The dashboard filter is set to exclude the selected value.

💡 Hint

Check the parameter action configuration carefully.

If the parameter action is not linked to the correct source sheet or target parameter, it will not update the parameter value when interacting with the dashboard.

🎯 Scenario

expert

Complex Parameter Action Scenario

You have a dashboard with a parameter SelectedYear and two views: a line chart showing sales over months and a table showing detailed sales data. You want the user to click on a month in the line chart to update SelectedYear and filter the table to show sales only for that year. However, clicking the month does not update the table. What is the best approach to fix this?

A Ensure the parameter action updates <strong>SelectedYear</strong> from the month field, and the table uses a calculated field referencing <strong>SelectedYear</strong> to filter data.

B Replace the parameter action with a filter action directly filtering the table by month.

C Create a new parameter for month and link it to the table filter instead of <strong>SelectedYear</strong>.

D Use a dashboard action to refresh the data source after clicking the month.

💡 Hint

Parameters do not filter data directly; they must be used in calculations or filters.

Parameter actions update the parameter value, but the views must use that parameter in calculations or filters to reflect changes. The table should filter data based on a calculated field that references SelectedYear.