Date slicer with "between" option - Should default dates to last 90 days

[sbeeram]

Hi

I have date dimension table and is linked to main data table with date. My client wants date slicer to be "between", but default dates to last 90 days e.g. if today is 09/03/2020, then date slicer should display 06/03/2020 to 09/03/2020. The slicer should automatically roll every day when the report is refreshed.

I know that "relative date" works, but it won't let the users to select random dates. Tried to place two date filters on a single page, one with 90 days filter and other for random date search, but the 90 days filter interfers with radom date slicer. 

I used DAX filter by calculating "last 90 days", but that limits users. It will not allow users to select random dates. 

This should be simple, but somehow it is not straightforward or is there some other way to do?

Please guide me.

[Greg_Deckler]

@sbeeram - I do not know how you satisfy your requirement where you would default to the last 90 days but the user could override that unless you did some things directly in your measures to default to the 90 days but that gets overridden based on some condition, like the maximum date chosen is < TODAY() or the minimum date chosen is > or < TODAY() - 90.

[amitchandak]

@sbeeram , refer if this can help

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

I doubt you will able to default the slicer like that.