Filters, Parameters and Actions Interview Questions for Tableau
31 Filters, Parameters and Actions questions with answers for tableau roles — 11 easy, 12 medium, 8 hard.
About Filters, Parameters and Actions
Add interactivity with filters, context filters, relative dates, parameters, dynamic parameters and dashboard actions such as filter, highlight, URL, parameter and set actions. Learn measure and dimension switchers, what-if analysis, Top N controls and drill downs, and how filter choices affect performance and row-level security.
Sheet progressStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
Tableau has extract filters, data source filters, context filters, dimension filters, measure filters, table calculation filters and date filters such as relative date, range and individual dates. Filters can be shown as quick filter controls like dropdown, single value list, multiple values list, slider or wildcard match. Each type applies at a different stage in the order of operations.
A context filter is an independent filter that runs before other dimension filters, Top N filters and FIXED LODs. Tableau creates a temporary result set from it, and other filters work on that subset. Use it when Top N should apply within a selection, such as top 10 products within a chosen region. Context filter pills turn grey in the Filters shelf.
A parameter is a user-controlled variable, such as a number, date or string, that is not tied to the data. It does nothing alone; you reference it in calculations, filters, reference lines, Top N or bins. Examples are a measure switcher, a what-if discount rate, or a dynamic Top N. Parameters can be shown as dropdowns, sliders or type-in fields.
04
What is the difference between a filter and a parameter?
A filter directly restricts data in the view based on field values and can show multiple selections. A parameter is a single value variable that users change, and it affects the view only through calculations or features that reference it. Filters are tied to data fields; parameters are global and can be used across data sources, making them useful for switching measures or dimensions.
Dashboard actions add interactivity. Filter actions filter target sheets based on a selection, highlight actions emphasise related marks, URL actions open a web page with field values, Go to Sheet actions navigate, parameter actions change a parameter value by clicking, and set actions change set membership. Actions can trigger on hover, select or menu, giving users guided exploration.
Relative date filters show data relative to today or an anchor date, such as last 7 days, this month, previous quarter, or year to date. They update automatically each day, so dashboards always show current periods without manual editing. You can set an anchor date for testing or use a parameter, and choose whether to include null dates.
07
A user wants the region filter on one sheet to apply to all dashboard sheets. What do you do?
Right-click the filter pill or quick filter and choose Apply to Worksheets, then either All Using Related Data Sources, All Using This Data Source, or Selected Worksheets. Pick the sheets on the dashboard. If sheets use different sources, ensure the field is related or use a parameter. Test each sheet after applying.
08
Top 10 products do not change when the user selects a region. Why?
Top N filters run before normal dimension filters, so Top 10 is computed on all regions, and then the region filter removes some of those products. Add the Region filter to context, so it runs first and Top 10 is calculated within the selected region. The Region pill turns grey to show it is a context filter.
09
What do you do when you are stuck on a Tableau problem?
Situation: in my internship I could not get a running total to restart each year. Task: solve it without wasting a day. Action: I reproduced it on sample data, checked documentation on addressing and partitioning, tried Specific Dimensions, and asked a senior with a clear description when still stuck. Result: I fixed it within an hour and wrote a note for the team.
10
How do you add a date range filter showing the last 12 months?
Drag Order Date to Filters, choose Relative Date, select Months and Last 12 months, optionally anchoring it to a specific date. Right-click the filter and choose Show Filter so users can change it. If data has a lag, anchor to the latest date in data using a parameter. Check the view title to display the active date range.
11
What is a highlight action and when is it better than a filter action?
A highlight action emphasises related marks across sheets and dims others, without removing data. It is better when users need to see the selected item in context, such as one category within the total. Filter actions remove other data and change totals. Highlighters can also be added from a field's menu so users can search and highlight specific values.
Since version 2020.1, parameters can refresh their list of values or current value from a field when the workbook opens. For example, a date parameter can default to the latest date in the data using a calculation like MAX([Order Date]), and a list can pull current region names. This removes manual maintenance when new values appear in data.
13
What is the difference between Only Relevant Values and All Values in Database?
For quick filters, All Values in Database shows every value of the field regardless of other filters. Only Relevant Values shows only values that remain after other filters, creating cascading filters such as states within the selected region. Relevant values need extra queries and can slow dashboards, so use them carefully on large data. All Values in Context is another option.
Create an integer parameter Top N with a range 5 to 50 and step 5. Drag Product to Filters, open the Top tab, choose By field, select Top and pick the Top N parameter, by SUM of Sales. Right-click the parameter and Show Parameter. Add region to context if Top N should apply within the selected region.
15
Build a dimension switcher so users choose Region, Category or Segment.
Create a string parameter Dimension Choice with values Region, Category and Segment. Then:
Selected Dimension:
CASE [Dimension Choice]
WHEN 'Region' THEN [Region]
WHEN 'Category' THEN [Category]
ELSE [Segment]
END
Put Selected Dimension on Rows and show the parameter control.
16
How do you create a filter action from a map to other sheets?
Go to Dashboard, Actions, Add Action, Filter. Choose the map as source sheet, select the target sheets, set run on Select, and choose what happens when clearing the selection, such as Show all values. Under Filter, choose Selected Fields and map State to State. Test by clicking a state and checking that the bar and trend charts update.
17
The dashboard should open showing yesterday's data by default but allow users to change the date. How do you do it?
Create a date parameter with dynamic current value from a calculation such as MAX([Order Date]) or TODAY()-1, refreshing when the workbook opens. Filter the data with a calculation [Order Date] = [Selected Date] set to True. Show the parameter control. Users get yesterday by default and can pick another date without editing the workbook.
18
Users complain that a dashboard with 10 dropdown filters is slow. How do you improve it?
Measure first with performance recording. Reduce the number of quick filters and replace some with dashboard filter actions. Change Only Relevant Values to All Values in Database where cascading is not needed. Add an Apply button to multi-select filters, convert high-cardinality filters to wildcard search, and move fixed restrictions to data source filters. Re-test after changes.
19
A business user wants a what-if analysis for price increase on profit. How would you build it?
Create a float parameter Price Change with a slider range of -20 to 20 percent. Build calculations: New Revenue = SUM([Sales]) * (1 + [Price Change]) and New Profit = New Revenue - SUM([Cost]). Optionally include an elasticity parameter for demand change. Show current versus projected profit side by side, and label assumptions clearly on the dashboard.
20
How do you gather requirements before building a dashboard?
Situation: a supply chain team asked for an inventory dashboard without clear details. Task: understand what they needed. Action: I met users to ask which decisions they make, which KPIs and filters matter, refresh frequency and who will use it, then sketched a wireframe and confirmed it. Result: the first version was accepted with only minor changes, saving rework time.
21
Tell me about a time you handled conflicting requests from two teams.
Situation: finance wanted revenue after returns while sales wanted gross revenue on the same dashboard. Task: satisfy both without confusion. Action: I arranged a short call, documented both definitions, and added a parameter to switch between gross and net with a clear label and tooltip definitions. Result: both teams used the dashboard, and the definitions became part of our data dictionary.
A URL action opens a web page, a file or an email link using field values from the selected mark. For example, clicking an order can open the order details page in an internal system with the Order ID passed in the URL, or clicking a company can open a search. URL actions can open in a new tab or inside a web page object in the dashboard.
23
How do you show a dynamic title that reflects the selected filter?
Double-click the sheet title and use Insert to add fields or parameters, for example Sales for <Region> in <Parameters.Year>. For multiple selected values, the title shows All or the value list; for cleaner text, create a calculation that returns the selection or All, using a FIXED or table calc approach. Dynamic titles reduce confusion during presentations.
A filter action removes data from target sheets based on a selection. A set action changes membership of a set, keeping all data available, so you can compare selected versus unselected, colour them, or build proportional brushing and drill-down within the same sheet. Set actions offer more flexible interactions, such as asymmetric drill down in a hierarchy, without losing context.
25
What are the performance impacts of quick filters?
Every quick filter with Only Relevant Values sends extra queries to fetch domain values, and multiple value lists on high-cardinality fields like Customer Name are expensive. Many filters also slow rendering. Use action filters from charts instead, use Apply buttons, prefer All Values in Database for large lists, filter dates with ranges, and push data source filters for fixed restrictions.
26
How do you use a parameter action to let users click a bar and change a reference line?
Create a float parameter, for example Selected Value. Add a reference line using that parameter. Then go to Dashboard, Actions, Add Action, Change Parameter, choose the source sheet, target parameter Selected Value, and source field SUM(Sales), with aggregation set as needed. Clicking a bar updates the parameter, and the reference line moves to compare other bars with it.
Create a set on Category. Build a calculation: IF [Category Set] THEN [Sub-Category] ELSE '' END, and place Category and this calculation on Rows. Add a set action on select that assigns values to Category Set and removes them when cleared. Clicking a category expands only its sub-categories, creating an asymmetric drill down that standard hierarchies cannot do.
28
Clicking a chart filters others, but users get confused when everything goes blank. How do you improve the experience?
Set clearing behaviour to Show all values instead of Exclude all values, add clear titles that show the current selection using dynamic text, and add an instruction line such as Click a region to filter. Use highlight actions where filtering is unnecessary. Provide a reset button through a parameter action or navigation button, and test with real users.
29
You must ensure sales managers only see their own region on a shared dashboard. What approach do you take?
Implement row-level security rather than relying on filters users can change. Use a user mapping table with usernames and regions, relate it to the data, and create a data source filter USERNAME() = [Username]. Publish the data source with the filter so it cannot be removed. For large deployments, consider virtual connections with data policies. Test by impersonating users on Server.
30
How do you prioritise dashboard requests from multiple stakeholders?
Situation: I received eight dashboard requests in one week as the only senior BI developer. Task: deliver the most valuable work first. Action: I listed requests with business impact, effort and deadlines, reviewed them with my manager, delivered quick wins using existing data sources, and shared timelines for the rest. Result: high-impact requests were delivered on time and stakeholders appreciated the transparency.
31
How does cross-database filtering work in Tableau?
When a dashboard uses multiple data sources, you can apply a filter to all related data sources if a field is related through blending or defined relationships via Data, Edit Blend Relationships. Tableau maps the field between sources, so one quick filter controls sheets from different sources. Mismatched values between sources will not filter correctly, so field values must align.
Frequently asked questions
How important is Filters, Parameters and Actions in Tableau interviews?
Add interactivity with filters, context filters, relative dates, parameters, dynamic parameters and dashboard actions such as filter, highlight, URL, parameter and set actions. Learn measure and dimension switchers, what-if analysis, Top N controls and drill downs, and how filter choices affect performance and row-level security.
How should I use the Filters, Parameters and Actions sheet?
Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.