Date Filter: How to make sure users cant type a date in the future?

[SvenV_98]

I have a date table with dates that end at the end of the last finished month. I have a between slicer with a start and end date.

The table is filtered in Power Query, filtered on the visual, has a measure that show if the month is finished to use as a filter. All of them have been applied and work great if you open the calender (greyed out future dates). But when the user types in a data manually it does not verify if that date exists. It just selects it and ruins the data.

How do I prevent the user from entering a date in the future?

[alish_b · Accepted solution]

Hey @SvenV_98 ,

Its a glitch in the system. I think I went down a rabbit hole around one and a half year ago for this but long story short, Power BI will not stop the user from manually entering the future date. Internally though, it will take the maximum date in the date table allowed in the filter context (check by populating a card visual by dragging and dropping the date field and changing aggregation from earliest date to latest date). Since there was no workaround, I added a filter summary table in the report populating it with the actual end date that was being applied internally. So yeah, it is just a frustating limitation.

Hope it helps!

[SvenV_98]

Thanks for the clear response. You are absolutly right. I've made some measures to verify that the future dates are not used. I've selected almost 3 years of dates, and it returned 23 full months, that matches the amount of months between 1-1-24 and 30-11-2025. 

[amitchandak]

@SvenV_98 , Use a relative date visual level filter. It will disable all future date 

[SvenV_98]

Unforunatly this does not work. It will for the calender selector, but not for the manual date entering:

Before entering the date manualy:

After entering the date manualy:

[amitchandak]

@SvenV_98 , I think it is by design to allow entering dates beyond the range if needed.