Forum Discussion
Date Range Slicer Question
Hi all,
Does anyone know why my dates are showing in my Report 1 and Report 2 filters when my selected range is before the date.
For e.g. the date slicer is showing 01/01/2021 - 01/12/2022 but my 'Date created' dates are 22/12/2022.
How do I only show the filter dates that are within the selected date range?
My report 1&2 filters are connected to
1. Make sure that all the dates are dates - not datetime
2. Disable "Both way relationship", calendars should almost always be one direction filters from calendar to dataset
I think this will solve your issue. 🙂
1 Reply
1. Make sure that all the dates are dates - not datetime
2. Disable "Both way relationship", calendars should almost always be one direction filters from calendar to dataset
I think this will solve your issue. 🙂