A static chart answers one question. An interactive Tableau dashboard lets a manager click a region and see every chart update, answering the next question too. Filters and dashboard actions make that possible.
Filters on a dashboard
Drag a field to the Filters shelf, right-click it and choose Show Filter to give users a dropdown, list or slider. On a dashboard, use the filter’s menu and choose Apply to Worksheets, then Selected Worksheets or All Using This Data Source, so one filter controls several charts.
Filter actions: click a chart to filter others
Choose Dashboard, then Actions, then Add Action, then Filter. Set a source sheet (for example a map of regions), the target sheets, and whether it runs on Select or Hover. Now clicking Karnataka on the map filters the sales trend and product table to Karnataka. Choose what happens when the selection is cleared: show all values is usually the friendliest option.
Highlight actions
A highlight action keeps all data visible but greys out everything except the selected category. It is useful when context matters, such as seeing one product line against all the others.
Parameters for user choices
A parameter lets users switch what a chart shows, for example choosing between Sales, Profit and Orders in one chart. Create the parameter, use it in a calculated field with CASE, and show the parameter control on the dashboard.
Keep it fast and clear
- Use extracts rather than live connections for large data when real-time data is not needed.
- Limit the number of quick filters; each one runs a query.
- Add a short instruction such as “Click a region to filter”.
- Fix the dashboard size so the layout does not jump on different screens.
Portfolio idea
Build a sales dashboard with a region map, a monthly trend and a top-products table, connected by one filter action and one parameter. It shows employers you understand interactivity, not just chart types.
Related: Tableau calculated fields, Power BI vs Tableau and choosing the right chart.
Tableau and Power BI are taught with projects in our 5-month Data Analytics course in Bangalore.
Book a free demo class at our BTM Layout centre, and ask a counsellor for batch details.
