Forum Discussion
Custom date slicer range
I have a model with a 2-year date range (1/1/2019 to 12/31/2020). How do I set up a slicer to only show those date ranges with the between filter? Currently it is enabling users to select dates outside of this range and adding my date table to the page filter isn't resolving it. Curious if there's a DAX expression to resolve this, as it appears Power BI isn't "smart" enough to default slicers to sync with the date range in the date table unfortunately.
1 Reply
Anonymous , Check out. Seem like even if your column does not have dates or even if you put a filter of not blank. It does work. So dates are unrestricted in the range filter.
