How to apply multiple filters at once?

Question & Answer
,
1

I have a dashboard with single sheet - multiple visuals and multiple filters.

I don’t want QuickSight to process data every time user edit each filters? It creates very heavy overhead when user want to change multiple filters.

I did “Update visual manually” selection, it works perfect in analyses. I get an “Update” selection on the top left corner in analyses.
But, when I publish the analyses as dashboard, the update button doesn’t show up. And the visuals starts auto-updating as soon as any filter is changed.

image
image776×158 7.84 KB

image

2

A couple of questions:

Is your dataset SPICE or direct query? With spice there will be no overhead because it has already loaded the data.

Second question, are you filters applied to all visuals?

image
image535×602 27 KB

3

  1. Spice - Overhead for the stakeholders as we have a heavy dataset with multiple calculations. It takes roughly 30-45 secs for the visuals to load after any filter change. So, useful for them to set multiple filters and then do apply that way the visual loads just once.

  2. All visuals on the sheet (done by selecting all visuals from Some visuals option)
    @Max

4

If all visuals on the sheet are attached to a filter then it will updates those visuals.

5

Hi Max,

Maybe you’re misinterpreting the question here. Sorry for that confusion.

The original ask:
Dashboard has multiple filters (say 10), I want to go give the stakeholder the ability to select values from N filters of those 10 before the visuals starts refreshing… So, basically single update for multiple filters rather than refreshing each time any 1 filter is changed.

“Update visual manually” works fine in Analyses but, I don’t see Update button in dashboard

6

I’ll mark it as a feature request.

8

Thanks! This is a known request, and the team is working on some options for user to refresh for a batch of controls. Thanks for the feedback!

@Rushabh_Vora