Click to apply all slicers button in Power BI Desktop same as Apply button for Filter Pane

[jaysgovindiya]

Hi,

I have created one Power BI report using Dynamic M Query parameter (Direct Query) to build SQL query I am selecting parameters from Import mode tables via slicers and then pass same value to Power Query to fetch data.

i.e. Having Category, Sub Category and Product slicers then It should display Monthly Revenue for selected product.

Currently it apply changes directly as per default behaviour and load chart but I want one button (Apply) and then it should pass slicer value to Power Query.

Can any one suggest for same? 

Thanks

[jaysgovindiya]

thanks @Idrissshatila 

It worked and as per requirement I can able to plot dynamic M query visuals after Apply slicers button

[Idrissshatila · Accepted solution]

Helllo @jaysgovindiya ,

check the apply all filters button https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=p...