Filter actions in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Filter Actions in Tableau

Which of the following best describes what a filter action does in Tableau dashboards?

A It changes the data source connection to a different database.

B It exports the dashboard data to an Excel file.

C It allows users to click on a mark in one view to filter data in another view.

D It automatically refreshes the dashboard every minute.

💡 Hint

Think about how clicking on one chart can affect another chart in a dashboard.

Filter actions let users interact with one view to filter data shown in other views, making dashboards interactive and focused.

❓ dax_lod_result

intermediate

Filter Action Effect on Dashboard Views

In a Tableau dashboard, you have two views: Sales by Region and Sales by Product. You set a filter action on the Sales by Region view to filter the Sales by Product view. If you click on the 'West' region in Sales by Region, what will the Sales by Product view show?

A Sales data only for the 'West' region across all products.

B Sales data for all regions and all products.

C Sales data for the 'West' region and only the top-selling product.

D Sales data for all regions but only for products sold in the 'West' region.

💡 Hint

Filter actions limit the data in the target view based on the selection in the source view.

Clicking 'West' filters the Sales by Product view to show only products sold in the West region, so sales data is limited to that region.

❓ visualization

advanced

Choosing the Right Filter Action Behavior

You want a filter action in Tableau that filters another view only when a user selects a mark, but clears the filter when the user clicks outside the marks (deselects). Which filter action setting should you use?

A Run action on Select and Show All Values When Clearing the Selection.

B Run action on Menu and Keep Filtered Values.

C Run action on Hover and Keep Filtered Values.

D Run action on Select and Keep Filtered Values.

💡 Hint

Think about how the filter behaves when the selection is cleared.

Setting the action to run on Select and choosing to show all values when clearing the selection means the filter applies on selection and clears when deselected.

🔧 Formula Fix

advanced

Troubleshooting a Filter Action Not Working

You created a filter action in Tableau to filter a target worksheet based on a source worksheet selection. However, when you click a mark in the source, the target view does not update. Which of the following is the most likely cause?

A The data source is set to live connection instead of extract.

B The dashboard is not published to Tableau Server.

C The filter action is set to run on Hover instead of Select.

D The source and target worksheets do not share any common fields used in the filter action.

💡 Hint

Filter actions require a common field to filter between views.

If the source and target views do not share a common field, the filter action cannot apply any filter, so the target view remains unchanged.

🎯 Scenario

expert

Designing a Complex Filter Action Scenario

You have a dashboard with three views: Customers, Orders, and Products. You want to set up filter actions so that selecting a customer filters Orders to show only that customer's orders, and selecting an order filters Products to show only products in that order. Which sequence of filter actions should you configure?

A Filter action from Products to Orders, and filter action from Orders to Customers.

B Filter action from Customers to Orders, and filter action from Orders to Products.

C Filter action from Orders to Customers, and filter action from Products to Orders.

D Filter action from Customers to Products, and filter action from Products to Orders.

💡 Hint

Think about the natural flow of filtering from customer to order, then order to product.

The correct setup is to filter Orders based on Customers selection, then filter Products based on Orders selection, creating a logical drill-down.