Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
alby696
New Member

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

Screenshot 2023-01-10 alle 09.01.19.png

Date 15/11/2022

Screenshot 2023-01-10 alle 09.01.33.png

 

Date 20/08/2023

Screenshot 2023-01-10 alle 09.01.49.png

 

Es. Full year

Screenshot 2023-01-10 alle 09.02.14.png

 

Thanks

alby696

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.