Support for an "Apply Filters" Button Instead of Automatic Refresh

Q&A
,
1

Is there a way in Amazon QuickSight to disable the automatic refresh of visuals whenever a filter value is changed and instead allow users to apply all filter changes at once?

Our use case involves dashboards with multiple filters. Users often need to modify several filters before analyzing the data. Currently, every filter change immediately refreshes the visuals, resulting in multiple unnecessary queries and a less efficient user experience.

Ideally, we would like the following behavior:

  • Users can change the values of multiple filters without triggering a dashboard refresh.
  • All filter changes are temporarily staged.
  • Once the user has finished selecting the desired filter values, they click an “Apply Filters” button.
  • The dashboard refreshes only once, applying all filter changes simultaneously.

Is this functionality currently supported in Amazon QuickSight, or is there a recommended workaround to achieve this behavior?

2

Hi @01267ts,

There’s no built-in “Apply Filters” button out of the box, but there’s a workaround using parameters and a button-style control that achieves what you’re describing. Another user also had this question a while back, here is the link to that thread: How to create 'apply button' for control - #13 by andyxson .

The approach is that, instead of connecting your controls directly to filters, you connect them to parameters. These parameters stage the user’s selections without triggering any visual refresh. Then you create a separate “Apply” parameter (acting as a button) that, when clicked, triggers the actual filters to evaluate against the staged parameter values. This way, users can change multiple selections and the dashboard only refreshes once when they click Apply.

Hope this helps!