Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
GeorgeG
Helper I
Helper I

How do I change filters with bookmarks?

Hi, I have a report, in which I have created a Today button and Yesterday Button.

When the buttons are clicked, I want my relative date filter to change to Today, or Yesterday.

For example, when I click the Today, it should change to this:

GeorgeG_0-1600281575210.png

I cannot find a way to assign a bookmark to just one filter. If I choose "All Visuals" for the bookmark option, it successfully changes the filter as explained above, but clears all filters on all my visuals. 

Because the filter changes when using the "All Visuals" option, it shows that bookmarks can in fact change the filter pane, but I can't find a way to select a filter when updating the bookmark.

 

I'm looking if there is anyway to achieve this, or perhaps a work around if it hasn't been implemented into PowerBI yet.

 

Thank you,

 

1 ACCEPTED SOLUTION
Sumanth_23
Memorable Member
Memorable Member

Hello @GeorgeG - PowerBI does not have an easy option to update your reports and default to the current day.

You can use one of the following approaches:

1. Set the default value in targeting based on user selection

https://www.youtube.com/watch?v=pCgK-Ze3nhA

2. Set the value of the slicer today based on a calculated column in your date model

https://www.youtube.com/watch?v=lkHFpmA4SJ4

Please mark the post as a solution and provide a 👍 if my comment helped resolve your issue. Thank you!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

1 REPLY 1
Sumanth_23
Memorable Member
Memorable Member

Hello @GeorgeG - PowerBI does not have an easy option to update your reports and default to the current day.

You can use one of the following approaches:

1. Set the default value in targeting based on user selection

https://www.youtube.com/watch?v=pCgK-Ze3nhA

2. Set the value of the slicer today based on a calculated column in your date model

https://www.youtube.com/watch?v=lkHFpmA4SJ4

Please mark the post as a solution and provide a 👍 if my comment helped resolve your issue. Thank you!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors