Limiting date range slicer

Hi Koritala 

 Add a relative date filter in the filter pane for the last 90 days. It should be at the page level to enforce across all visuals.

I hope this helps, please give a thumbs up and mark as solved if it does, thanks!

Hi Koritala,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to MohamedFowzan1, wardy912, for those inputs on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

I am also including .pbix file for your better understanding, please have a look into it:

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

Hi Koritala 

• Two Slicers Approach – Use separate From and To date slicers from your Date table instead of a single range slicer.
• DAX to Enforce Limit – Create a measure to capture the selected From date and restrict the To date to within 90 days using a filter.

• Create a measure for the minimum selected "From" date:

• FromDate = MINX(ALLSELECTED('Calendar'[Date]), 'Calendar'[Date])

• Create a measure that checks if the "To" date is within 90 days of the "From" date:

• Measure = IF(
  MAX('Calendar'[Date]) >= [FromDate] && MAX('Calendar'[Date]) <= [FromDate] + 90,
  1,
  0
  )

• Apply this measure as a filter on the "To" date slicer visual, setting the filter to show only values where the measure equals 1. This restricts the selectable "To" dates to a maximum of 90 days after the selected "From" date.