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’m facing an issue with bookmarks in Power BI.
Scenario:
I have a Year slicer in my report.
I have two bookmark buttons:
Monthwise View → Shows a graph of Cost and Revenue by Month.
Yearwise View → Shows a graph of Cost and Revenue by Year.
When I click these buttons, the graph switches between Monthwise and Yearwise view as intended.
Problem:
When I created the bookmarks, I had to select a Year from the slicer.
Now, whenever I click either bookmark, it resets the slicer back to that default year instead of keeping the year I’ve currently selected.
What I’ve tried:
In the Bookmark settings, I deselected “Data”.
Despite this, the slicer selection still resets to the default year used when creating the bookmark.
Question:
How can I set up my bookmarks so that they change only the visual layout (Monthwise ↔ Yearwise) without altering the slicer selection?
Any suggestions or workarounds would be greatly appreciated!
Thanks in advance.
Hi @rithika99,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @danextian for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Hi @rithika99,
We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Hi @rithika99
I can't replicate your issue. You can see in the screenshot below that deselecting data from the options changes the display only. Please ensure that in both bookmarks, data is deselected. Alternatively, and if you only need to switch between dimensions, look into using field parameters on column instead - it is easier to maintain and implement.