Dynamic Dates in Visual Filtering

[alonardi]

Hi, how can I set dynamically the date when I use the filter visual with a date field using the “between” option and I record it in a bookmark? That fixed date generates an issue with the users that access the reports and often do not realize that they are not seeing the current period. I know how to update manually the bookmarks, but it is not easy as I have many reports. I would like to know if there is any option, trick or workaround solution to make dynamic the date of the bookmarks and set it always in date = "Today ()". Thank you so much

[v-shex-msft · Accepted solution]

HI @alonardi ,

You can write a measure to compare current row date and system date(use it as filter on visual level filter) and save to bookmark. Measure result will dynamic changes when report refreshed.

Regards,

Xiaoxin Sheng