Need to setup date slicer (between) having default FROM DATE as Start of month and TO DATE as today

[Anonymous]

Hi,

I have a requirement to setup date slicer (between) having default FROM DATE as Start of month and TO DATE as today. Users should also choose any date range from calendar. Please suggest.

Thank you!

[Alexx95]

You can do it for in many ways.
You can create a calendar table with dates (start,end) with ( date start, today() ) and this table update in every day automatically.

Maybe you can add a filter to the slicer with relative date in actually month.

If i understand correctly, you wanna 2 types of slicer at same time? You can add one date in slicer between and other with only months. then the user can select 01/06/2023 to today, and if you choise a month in the other slicer the user only can see the month.

[Anonymous]

Hi Alexx,

It is only one between slicer filter. 
How to set the default date in From and To date?

[Alexx95]

Add a filter to the slicer, if you have dates you can add a type of relative date, some likes in day, in week in moth, others...
BUT is not for default, i understand that is automatically with cache report, it means the default is the last filtered.