The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi!
I have been introduced recently by the Microsoft support team about bookmarks being the viable option for having a "reset to default" state button. However, I am facing another problem now, as while I wanted to reset a specific page to its default state, don't want that button to affect the report (all pages) - level filter. I have been wondering if there's a way to accomplish this? Thanks.
Solved! Go to Solution.
I'm not sure that I understood what you are trying to do you can also check the option of personal bookmarks ( but this functionality needed to be configured by every user separately ).
This is all we have...
There are no other "tricks" with resetting filters / slicers.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
The logic of this specific button is to return the report to its "published" state.
All other options need to create button / bookmark of the wanted state.
If the goal is to clear the slicers then you can use the button "clear all slicers" which is on the page level.
If it is something else you can create the page in the wanted state and save it as a bookmark.
The guide to accomplish both :
https://www.youtube.com/watch?v=ybRQPoLQ6eI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Ritaf1983 ! Thanks for the solution. Unfortunately, I need to reset the slicers (which are either fields with default values or field parameters with default selection) on the page, without affecting the report-level filter. I don't think your solution above works.
I'm not sure that I understood what you are trying to do you can also check the option of personal bookmarks ( but this functionality needed to be configured by every user separately ).
This is all we have...
There are no other "tricks" with resetting filters / slicers.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @PatrickGreen -
Go to the View tab and enable Bookmarks Pane.
In the Bookmarks pane, click Add to create a new bookmark.
Rename the bookmark to something like "Page Default".
While the bookmark is selected, ensure Data, Display, and Current Page options are checked (click the three dots next to the bookmark name to configure this).
Exclude Report-Level Filters:
To ensure the bookmark doesn't reset report-level filters:
Configure the bookmark to ignore any report-level filters by deselecting the Data option in the bookmark settings.
Alternatively, ensure that no report-level filters are modified when saving the bookmark.
Add the Reset Button:
Go to the Insert tab and add a Button (e.g., Blank, Reset, or any style of your choice).
In the button's Action settings:
Set Type to Bookmark.
Assign the "Page Default" bookmark to the button. test the button.
Hope the above detailed steps helps.
Proud to be a Super User! | |
Hi @rajendraongole1 ! Thanks. Unfortunately, this doesn't solve the problem, as I need the bookmark to reset all the slicers on the page, but not the report-level filter, if that makes sense.