Reset bookmark that sets date slicer to today

[alemoldav]

Hi everyone,

I have a date slicer in my report using the Date slicer with the "After" type.

( I have a calendar table generated in dax, and the date slicer is based on the 'Calendar'[Date] column )

I use this workaround beacuse I only need one single date from the slicer. In my measure, to retrieve the date I use:

Selected Date = MIN('Calendar'[Date])

This part works fine.

On the page I also have a "Reset" button linked to a bookmark, which is supposed to clear all filters on the page. The problem is:

when i click the reset button, the bookmark restores the date slicer to the date that was selected when i last updated the bookmark.

What i would like instead is: when I click the reset button, the date slicer should automatically go to today's date (maybe like using TODAY() function as default ? ), instead of the static date saved in the bookmark.

The actual state of the bookmark "Reset":

Is there any way to achieve this? Thanks!

[alish_b]

Hey @alemoldav ,

Give this a try:
1. Use a 'Before' filter instead of the 'After' filter. Now obviously, you can't resize like you can with the 'After', so put a white shape on top of the unwanted parts of the date slicer (should work seamlessly in Service with, and in Desktop being the development environment the illusion lasts until you double click on the slicer). Also add a text box separately for the Date Title :

2. Now your measure will be using Selected Date = MAX('Calendar'[Date])
3. Add a relative date filter for the whole page on the Calendar[Date] column with last X years including today:

4. Now if the bookmarks job is to just clear the filters, you could simply use the Insert> Buttons> Clear all slicers.

Finally, test if it is working as per your requirements.

Hope it helps!

[danextian]

Hi @alemoldav 

Bookmarks don’t have awareness of today’s date. A bookmark is simply a saved snapshot of the report’s state. It remembers exactly what was selected at the time it was created. So if the selection was “yesterday,” triggering the bookmark later will still select “yesterday,” not the new current date.

Slicer selections on the other hand rely on a column’s Group By property, which can be configured in Tabular Editor.

In the GIF below, the Date column’s Group By is set to the Offset column, and the selected offset value is –12. Even as the calendar table updates and actual dates shift, the offset value remains constant. So if the offset for today is 0 and today is selected, the slicer will automatically move to the new current date when TODAY changes – because the offset value is still 0.

However, this behavior works only with vertical slicers. Range and dropdown slicers do not respond visually to the Group By configuration in the same way — which is why the range slicer in the example does not update its selection.

Please refer to this video - https://youtu.be/MrEAZREQuXM

[alemoldav]

Okay, so there is no way to set the date filter i have in my report to the today's date, the only way to achieve this is to use the vertical slicer...

This works fine but i need in my report the date filter with the calendar..

Thank you anyway!

[v-tejrama · Accepted solution]

Hi @alemoldav ,

The total changing when you add a legend usually means the measure is reacting differently once the visual is split into categories. When the legend is added, Power BI recalculates your measure separately for each slice, and then adds them up which often doesn’t match the “true” total you expect. A reliable way to fix this is to calculate the core pieces of your measure (like Time Booked and Capacity) in a way that doesn’t depend on the legend’s filters.

You can do this by wrapping those base measures in REMOVEFILTERS() (or ALL()) so they always compute at the right level before the legend is applied. Once those pieces are stable, the total stays consistent even when you break the bars into categories. If the issue still appears after isolating the filters, then it’s likely due to how the visual calculates totals internally, and raising a Microsoft support ticket would be the right next step.

Thank you.

[v-tejrama]

Hi @alemoldav ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[v-tejrama]

Hi @alemoldav ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[lbendlin]

Don't use slicers.  Use the Filter pane. There you can specify Relative Date filters.

[Jihwan_Kim]

Hi,

One of ways to reset to today is, 
- use new-button-slicer

- create date order column in the calendar table that shows today = 0.
- insert date order column into new button slicer visualization

- do not show date order column on the slicer (turn off value), but show the measure as label (turn on label). 

- Note: the semantic model in the service has to be refreshed at least daily.

Please check the below picture and the attached pbix file.

[m4ni]

@alemoldav - firstly you probably want to untick Data in your bookmark settings (in your case - Dati) .  If this is ticked, the bookmark will remember the data/date in its state.  

Secondly, you cant really force todays date in the slicer.  Best option would be to have a relative date filter in the last x months/days etc so your slicer is largely dynamic and not fixed to a date.  

Please try these options to see if it helps, but you probably have to find some middle ground on what is actually practically possible and the functionality.  HTH