Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
With the current bookmark feature capabilities, is it possible to exclude drillthrough and page level filters from the bookmark. For example, I want to be able to clear filters from on-page slicers but not from the Filter pane. I tried to just include Selected Visuals. I selected all slicers, making sure they aren't filtered then proceeded to updating my bookmark. This attempt did not work either.
Proud to be a Super User!
Hi @danextian,
It seems that you are looking for PowerBI Drillthrough page with clear filter bookmark.
You could have a good reference of this video.
Best Regards,
Cherry
Hi @v-piga-msft,
Thanks for the response. I've watched the whole video but it is not the solution to my problem. In the video, the drillthrough filter still got cleared after clicking to bookmark button. What I want to achieve is just to be able to clear the the on-page slicers selection and not the drillthrough filters.
Proud to be a Super User!
I was able to achieve the desired behavior by using the "Selected visuals" instead of the default "All visuals" option for the bookmark.
On the drill-through page, select all visuals except the one slicer for the drill-through attribute (or any other you want to excldue from teh Bookmark reset action). Then add the bookmark, select the "Selected visuals" option and wire it to the Action button on the drillthrough page. Now whenever you drillthrough, then change slicer and filter values, then click the Reset button to the Bookmark, the drillthrough attribute remains untouched, while all other visuals reset to the bookmark status.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |