I have this standard, boring dashboard that shows details for 1-5 IDs at a time. The data source is HUGE (it takes ~10 seconds to query) and the query would run every time I selected an ID. So, if I needed to look at 100, 101, and 201 the process would look like this:
Open Filter, Select All
Open Filter, De-select All
Open Filter, Select 100
Open Filter, Select 101
Open Filter, Select 201
It was frustrating enough that editing the filter was easier than using the filter card. Not quite good enough for sharing!
Then I noticed that a production workbook wasn’t doing this! By looking at the filter I discovered how to add the Apply Button to filters.
Now the process looks like this: