Date Range Slicer between Dynamic Dates

Hello,

You can solve it by using a separate disconnected date table just for the slicer, then controlling what actually shows in visuals with a DAX measure, so the slicer always contains full range but default selection behaves like last 3 months. Another option could be using a relative date logic in a calculated table that still keeps all dates but adds a flag for default view, then use that only for initial filtering.

Best regards,
Daniele

ahmadwljfksqlid 

Use a relative date slicer. Set it to last 3 months. It updates automatically and users can still change the range.