Power BI Report: Slicer should set back to current date

[Gayathri_31]

Hi,

I have gone through several other posts which mention regarding updating the slicer date back to current date using dynamic slicer etc. My scenario is, if I change the date in the date slicer to some other date and save it and upload it in the report server, my customer should see the date slicer as current date when the report is opened. They don't want to do multiple clicks in the slicer to see the current date data. How to achieve this? 

[bchager]

@Gayathri_31 I'd use bookmarks and a bookmark navigator for that.

- Create a "DateSelection" column in the date table the way I did in the attached

- Use the DateSelection column as a page filter

- Create your bookmarks with each DateSelection selection

- Add a bookmark navigator

[danextian]

Hi @Gayathri_31 

This can be achieved by using Tabular editor. The method leverages the Group by Columns property to "store a filter by using an alternate value, which represents the key of the entity." Power BI uses this key to store the filter, allowing the corresponding filter value in the visual to change dynamically. For instance, if May-24 is selected in the visual and currently has a key of 0, when June arrives, May will shift to a key of 1, and June will take the key of 0. Consequently, the slicer selection will automatically change to June.

However, there is one limitation: when using a dropdown slicer, the selected date in the visual will not automatically update to reflect the date with a key of 0 unless the user interacts with it. For instance, if the date with a key of 0 was January 1, 2025, and today's date is January 2, 2025, the slicer will still display the former date as selected until the user interacts with it.

Please refer to this video -https://www.youtube.com/watch?v=MrEAZREQuXM 

Further reading is in the video description.

[Gabriel_Pedri]

Hello @Gayathri_31,

You could use a DAX measure to return the current date, so it will always be filtered by the current date.

CurrentDate = TODAY()

If you want it to be the date of the last update, we can do it through Power Query:

let
    Source = Date.From(DateTimeZone.RemoveZone(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -3)))
in
    Source

Another method is to set this directly on the page or visual through the 'Filters' tab.

If this response helped you, please click 'Solution'.

[Gayathri_31]

Thank you! But, this doesn't update the date to current date. I have change the date in Power BI Desktop to some other date and saved it and published it. There I see the changed date itself, not the current date. I want the customer to see the current date. The relative date is not helping.