Forum Discussion
Solved
Set dynamic default slicer selection
I have a report which can visualise data going back many years. I have a sliding ‘after’ date slicer with which the user can select a single date and filter out all data from before that date. What t...
well this is the solution that works for the last 14 days, if you want to add another slicer so the user would pick, it will reflects only 14 days unless the user clear the above slicer.
Hello Pandangus ,
yes you can do ths, check the following:
first you add the date to a slicer, then in the format visual you click on slicer settings => option => relative Date
then what you do is select last and you set the number then the interval which now in your case days