How to disable selecting old dates on a date slicer?

[wpf_]

I have a calendar table which uses calendarauto() and gives me just the dates for the year and use it in a slicer as a date picker.  I am using the calendar picker not the slider or drop down picker.  How can i disable the user from picking dates older then today?  in my calendar table i have a column that only shows dates from today onward.  Older dates show up blank.  And i am using this column in the slicer.  However when i pick an older date, the slicer still shows the older date even though the data is today's date (min).  So this could confuse users.  I am trying to avoid using a slider or drop down.  Thanks. 

[Anonymous · Accepted solution]

Hi @wpf_ 

If you only want to show dates after today in your date slicer, you can try to build a filter measure.

I build a Date table by calendar function.

Date = 
CALENDAR(DATE(2021,01,01),DATE(2021,12,31))

Measure:

Slicer Filter Measure = IF(MAX('Date'[Date])<TODAY(),0,1)

Add this measure into your slicer and set it to show items when the value equal to 1.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@wpf_ , if you are using calendar date picker, between range?

I think that is able to show dates in the past even if they are not available. 

[wpf_]

@amitchandak 

Is there any way to get around this?  Even if i just want to display a messsage that they can't show it?