is there a way to make changing slicer not refresh data right away?

[jasonyeung87]

Hi,

I'm developing a Power BI report that has a few slicers. These slicers filter the data displayed in the reports when its value changes right away (e.g. if I have a slicer of created years and it's displayed as a drop-down, changing option from 2022 to 2021, the data will refresh from ones created in 2022 to 2021 right away).

I want to change the user interface so that when you change a slicer's value, it won't refresh the data until a button is clicked. This is similar to the UI in a web page, where you fill out the form, but nothing happens until you click the submit button.

I was wondering if it's possible to have this UI in Power BI? 

Sincerely,

Jason

[jasonyeung87]

Hi @lbendlin ,

thanks for your help. It worked for me.

Sincerely,

Jason

[lbendlin · Accepted solution]

yes, there is

Format filters in Power BI reports - Power BI | Microsoft Docs