Forum Discussion
Bookmarks do not save "Select all"
- 1 year ago
Thankyou, djurecic, for your response.
Hi Starrburst,We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.
Based on my understanding, Bookmarks in Power BI do not capture or retain the state of the Select All toggle button, even when the Data option is enabled within the bookmark settings. While bookmarks are capable of capturing selection states, deselecting all values to simulate the Select All being OFF does not actually toggle the Select All button off; it merely alters the selected filters. The Select All user interface state remains unchanged.
As a workaround, we have implemented bookmark based selection states as follows: Select All ON corresponds to no slicer filters applied (i.e., the slicer is cleared), and Select All OFF corresponds to a few categories explicitly selected. By toggling between these states through buttons and bookmarks, we have successfully simulated the intended toggle functionality without impacting other slicers.
Please find attached screenshots and a sample .pbix file for reference:
When 'Select All OFF' is selected:
When 'Select All ON' is selected:
We hope that the information provided will assist in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.Thank you.
That does work to turn the "Select all" to on, but having a bookmark with the "Select all" in the off state does not switch "Select all" to off.
Forgot to mention I am on 2.139.1678.0 64-bit (January 2025)
In Power BI by default, Select All will produce the same result as selecting nothing. Here is a workaround using the DAX function ISFILTERED.