'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Keep a Power BI Slicer Selection When Changing Bookmarks
Question details
The user wants to maintain an active slicer selection (such as a conference name) without it resetting when navigating between different preset bookmarks.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Navigating between pre-configured bookmarks in a Power BI dashboard without losing the user's current slicer filtering.
- Observed behavior
- Clicking a bookmark currently applies its preset filters and clears any previous slicer selections made by the user.
Ensure you have edit permissions for the Power BI report and save a backup copy of your dashboard before modifying bookmark behaviors.
Disable the Data Property in Bookmark Settings
Modifying the bookmark properties to ignore the saved data state prevents the bookmark from overriding your current slicer selections.
By default, Power BI saves the exact data state (including filters and slicers) when a bookmark is created. To prevent a bookmark from resetting a slicer, you must configure the bookmark to only update the visual display rather than the underlying data state.
Open your report in Edit mode. Navigate to the View tab on the ribbon and select 'Bookmarks' to display the Bookmarks pane.
In the Bookmarks pane, locate the bookmark that is resetting your slicers. Click the ellipsis (...) next to the bookmark name to open the context menu.
In the context menu, click on 'Data' to uncheck it. When the checkmark is removed, the bookmark will no longer capture or apply data properties, leaving your active slicer selections intact.
Repeat this process for any other bookmarks in your report where you want the slicer state preserved across navigations.
Consult the Power BI Community
For complex bookmarking scenarios involving sync slicers or advanced DAX, community specialists provide tailored guidance.
Manage Your Data Efficiently with WPS Office
While Power BI is excellent for complex interactive reporting, everyday data management, filtering, and preliminary analysis are often best handled in robust spreadsheets. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, featuring powerful spreadsheet tools to process your data flawlessly before importing it into BI tools.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Prepare Your Data: Open WPS Spreadsheet, import your raw data files, and clean or format the data using familiar Excel-like formulas.
- 3. Create Slicers: Highlight your data, insert a PivotTable, and use the Slicer tool to instantly filter and analyze your metrics without complex BI configurations.
Frequently Asked Questions
Why do my slicers reset when I click a bookmark in Power BI?
By default, Power BI bookmarks save the exact 'Data' state—which includes slicer selections, sorting, and filters—at the moment the bookmark is created. Clicking the bookmark restores that exact historical state, clearing any new selections you made.
Can I apply the 'Data' bookmark setting to specific visuals only?
Yes. In the Bookmarks pane, you can select specific visuals on your canvas, click the ellipsis next to your bookmark, and choose 'Selected visuals' rather than 'All visuals'. This limits the bookmark's effect solely to the items you highlighted.
How do I make a slicer affect all pages in Power BI?
You can use the 'Sync Slicers' pane (found under the View tab). This feature allows you to link a slicer so that a selection made on one report page automatically filters the data on other pages.
Where can I get advanced help for Power BI dashboard issues?
For complex behavioral queries regarding DAX, custom visuals, and bookmark logic, the official Microsoft Power BI Community and Microsoft Fabric Community are the best resources to get assistance from dedicated specialists.
