Forum Discussion
Filter Date Dinamically
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
1 Reply
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
