Forum Discussion
Helper IDate Slicer - Restricting Min and Max Date
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.
Helper ISorry if my explanation was vague.
1- I need a date slicer, must be "between" style. This is a must asked by the customer.
my data starts from 1st October 2019 and when I add the field it automatically sets the earliest date, that's fine.
I also added the filter as you suggested.
2) I save it (I'm on desktop), I push it to the online service and everything is fine.
I open the report, I see the dates correct. Until I click on the slicer; as you can see I'm able to select before the earliest date set by me. This screenshot is from browser, user interface.
End user: "If I'm able to select, I want my report to start from that date. If I don't have the data, I don't want to be able to select, it confuses me because I'm end user not a nerd"
Long story short, my starting date shouldn't be able to be changed, which is 1st October 2019.
eg. 2nd October 2019 is okay, July 2015 is not okay.
Thank you people.
