Hi,
I have two date slicers and i would like to set default date ranges when open the report and also able to change any other date ranges
date slicer 1 should show default date range as start date is "current month 1st date and end date is current date".
date slicer 2 should show deafult date range as start date is "current date-5 and end date is current date".
date slicer 1: to set default date range i have created 2 columns
column1 for start date: IF('DATE'[YEAR]=YEAR(TODAY()) && 'DATE'[MONTH]=MONTH(TODAY()),1,0)
column2 for end date: IF('DATE'[date]<=TODAY(),1,0)
date slicer 2: to set default date range i have created 2 columns
column3 for start date: IF('DATE'[date]<=TODAY()-5,1,0)
column4 for end date: IF('DATE'[date]<=TODAY(),1,0)
i have used above four columns in both date slicers and set date filter=1 its working fine only when navigating the report data but when i open the report by default date ranges not working..
Please suggest how to set above default date ranges for both date slicers.
Thank you in advane for your help and suggestions.
Thanks,
Mahi1827
