Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
pawelj795
Post Prodigy
Post Prodigy

One-side date filter

Hi,
I have quick question.
Is it possible to set date filter only one-sided?
I mean, that user of my report can filter date only to desirable date, but start date cannot be change.

Also, I want to filter date only to current date, not for the future

image.png

5 REPLIES 5
rainer1
Resolver III
Resolver III

Hi,

Yes you can change the Slicer setting by hover the slicer. In the right corner you will see an arrow. See the Picture Below.

If you want to Limit the Date you can set a filter in the Filter Pane.

 

slicer.PNG

@rainer1 
No, it is not available in slicer settings.

I want to automatically limit date filter (not after today - something like that), not manually limit date fiter.

for filtering until e.g yesterday set the Visual Filter to Relative date filtering. Set your purpose and uncheck the button include today

 

date.PNG

please double check if the slicer header in format ist set to on.

 

slicer2.PNG

 

then you will see the arrow.

@rainer1 
I don't want "list" filter.
I want "beetween" filter, not after today, and start on particular date.

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.