Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
This is what my data look like:
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()))
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?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 50 | |
| 43 |