Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jai_Bankar
Helper I
Helper I

Using single button to perform two actions

Hi, I am using back button in my development, when i click the back button, the applied filters must be cleared out and also it must go to previous page.

Can we achieve this, please suggest any solution.

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @Jai_Bankar 

After some tests in the Power BI desktop, I think this function can be achieved using bookmark and Sync slicers. You can follow my steps:

  1. I created a Slicer on page2 and clear all filters then create a bookmark for page2
  2. I click the Slicer and click on the “Sync slicer” then set it like this:

v-robertq-msft_0-1611111306720.png

 

v-robertq-msft_1-1611111306725.png

  1. I go to the page1 , create a button and set the action to “Bookmark 2 ”:

v-robertq-msft_2-1611111306727.png

 

Then I click the button, I jumped up to the page2, then I go back to page1, I found the Slicer is cleared.

v-robertq-msft_3-1611111306728.png

And you can get what you want.

You can download my test pbix file here

More info about Sync and use slicers on other pages

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Rohit_dutta
Frequent Visitor

its not working in filter pane also

v-robertq-msft
Community Support
Community Support

Hi, @Jai_Bankar 

After some tests in the Power BI desktop, I think this function can be achieved using bookmark and Sync slicers. You can follow my steps:

  1. I created a Slicer on page2 and clear all filters then create a bookmark for page2
  2. I click the Slicer and click on the “Sync slicer” then set it like this:

v-robertq-msft_0-1611111306720.png

 

v-robertq-msft_1-1611111306725.png

  1. I go to the page1 , create a button and set the action to “Bookmark 2 ”:

v-robertq-msft_2-1611111306727.png

 

Then I click the button, I jumped up to the page2, then I go back to page1, I found the Slicer is cleared.

v-robertq-msft_3-1611111306728.png

And you can get what you want.

You can download my test pbix file here

More info about Sync and use slicers on other pages

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft
Community Support
Community Support

Hi, @Jai_Bankar 

What do you mean by “the applied filters must be cleared out”? If you want to clear the Slicer and the filters of the page you are going back to, you can create a bookmark for the backed page without any Slicer and filter. Then set the action for the Button, like this:

v-robertq-msft_0-1611025958599.png

 

v-robertq-msft_1-1611025958623.png

If you want to clear the filter in the original page when you click the back buttom, I don’t think it can be achieved. Because each buttom can only have one action. You can only create another buttom to reset the filer then click “Back” buttom to the backed page.

Resetting page back to defaults using the new buttons feature and bookmarks in power bi

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you!
My question was , I want to clear the filter in the original page when I click back button. But it's not possible to assign two actions for single button, can we have any other workaround for this issue?  

amitchandak
Super User
Super User

@Jai_Bankar , this seems like going to clear the slicer using bookmarks. I think create a clear a slicer bookmark on page 1 and use that on page 2 button

https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you!
Already tried this, works well , but my concern was, if i click back button, the filters applied in the current page should get cleared and then it should return to back page. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.