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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Julia2022a
Regular Visitor

How to grey out future dates in date slicer

Good morning,

 

Can you please teach me how to grey out future dates in the date slicer? I don't want people able to choose a future date in the date slicer. My data does not contain any dates after today but the when I click the date calendar slicer, it still let me choose future dates. Can someone help me? 

 

I am using the December 2020 version. Due to the company restriction, I can only use this version. 

 

Thank you very much for your help!

Julia 

 

Julia2022a_0-1667846772514.png

 

This is what my data look like:

 

Julia2022a_0-1667847343260.png

 

 

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

You can try adding the following measure as a filter in the Date table filter pane and set the value to = 1:

Filter dates = COUNTROWS (FILTER(Date Table, Date Table[Date] <= TODAY()))





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thank you @PaulDBrown. I tried it but still not working 😞 I can still choose future dates. Can you please let me know if I did anythign wrong?

 

Julia2022a_0-1667848687997.png

Julia2022a_1-1667848700700.png

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors