Filter Date Dinamically

[alby696]

Hello everyone,

Like every year, at the beginning of the year I have to go back through all the reports to change the default display date on the bookmarks.
I wanted to know if by chance there is a script that allows you not to do this, i.e. from the current date, it extracts the year and if necessary also the quarter so that the filter can be set automatically.

Es.

Date 01/01/2023

Date 15/11/2022

Date 20/08/2023

Es. Full year

Thanks

alby696

 

[Anonymous]

HI @alby696,

AFAIK, current power bi does not support dynamic setting slicer values. You can create a measure formula to compare with current system date and apply filter on ‘visual level filter’(this saved filter effect will dynamically change when system date changed) but not able to dynamic change the slicer selections.

Regards,

Xiaoxin Sheng