Forum Discussion
Helper IHow 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:
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,
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!
1 Reply
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!