Forum Discussion
Set dynamic default slicer selection
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
Hello Idrissshatila
Thank you so much for your response 😊 your solution works great on my end, and does show the data from the previous 14 days.
Though I do wonder if it is possible to enable the user to select a specific date using a calendar or slider, and display data from after that selected date. I know the user could achieve this by working out the number of days before the current date, and entering that number, but I wanted to make it as easy as possible for them by providing a calendar or slider for them to interact with if possible.
Anguswell 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.
That's a great idea. Thanks so much for your help 👍
