Forum Discussion
Helper IDate Slicer - Restricting Min and Max Date
Hello All,
The slicer already sets the min and max date from the column pointed.
But,
the end user is able to select any date from calendar dropdown.
Can I restrict the end user? I need that field to be invisible, or at least not pickable.
Thank you!
Hi Nooby ,
Based on my test, I created a date table only contains date from 3/1/2020 to 3/8/2020, yet i still can select date between 3/1/2020 or after 3/8/2020 from calendar dropdown.
I'm afraid we can't restricting min and max date for calendar dropdown currently but I'd like to suggest you to submit this as an idea through the below link.
https://ideas.powerbi.com/forums/265200-power-bi-ideas.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
NoobyHello MFelix,
I did so and you can restrict the "initial" dates, that's right. And people see what I want but they still can change the dates, even if that date interval doesn't have any data.
When you click on it, you can go back like 20 years ago. I cannot see any restriction for "not being able to select date". Maybe it's something easy but I cannot find it.
Thank you.
PaulDBrownCommunity Champion
Not sure what you mean by "they still can change the dates, even if that date interval doesn't have any data."
As MFelix suggests, you can restrict the dates using the filter pane. If you don't want users to meddle with the filter on the filter pane, there is an option to either hide or block the filter:
If you want the visual to display data with no blanks, you can add the measure to the filter pane and select "is not blank":
Does that help?
Hi Nooby ,
Based on my test, I created a date table only contains date from 3/1/2020 to 3/8/2020, yet i still can select date between 3/1/2020 or after 3/8/2020 from calendar dropdown.
I'm afraid we can't restricting min and max date for calendar dropdown currently but I'd like to suggest you to submit this as an idea through the below link.
https://ideas.powerbi.com/forums/265200-power-bi-ideas.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
