Add an "Apply All filter slicers" button

Currently, in #PowerBI, when configuring "#Query_Reduction" feature with slicers, in order to preserve report performance,  the only option available is the "Apply" button added to each slicer.

The idea is to create an "Apply All Filters" button, so that changes for all slicers can be applied via a single button.

The trick is very clever and simple, we need to 

Create two #bookmarks:

✔the first one for the hidden report without selections on the slicers + an "Apply all filters" button.

✔the second one with all visuals displayed and filtered + a button to "Reset filters".

==>It will be a significant performance gain when we use #direct_query, so we don't have to send a query to the source for each selection applied in a slicer

More details in Mara's blog: https://www.datapears.com/post/power-bi-query-reduction-add-an-apply-all-filters-button-to-your-report

#performance #powerbidesktop #DirectQuery #DAX #bookmark #visualization