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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Manjula
Helper I
Helper I

Power BI Dynamic Date slicers

Hi All,

I have requirement in our project to show report at date.
there is slicers effective end date and  below are the values

Manjula_0-1701281590545.png


but this slicer should show from 2 years untill current date, if user select any date before 8th nov the data should show same as selected 8th date , if user select any date after 9th of nov then data has to show 31/12/9999 selected value in slicer

please help how to achieve this 

1 REPLY 1
lbendlin
Super User
Super User

It is not possible to set the selected value in a slicer programmatically. 

 

Also, please do not use dates like 31/12/9999 - they are very bad for your dataset semantic model size, especially if you enable auto date/time. Instead, use BLANK().

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.