Forum Discussion
How can a Between date slicer default both dates to the latest available date after refresh?
Hello thegraphiccow ,
There is no direct way of achieving the same but you can do a workaround to achieve exactly the same without using relative slicers or snapshot.
1. Add a calculated column in your table like New Date column = Max ( SnapshotDate )
This will update with data refresh and always gives latest date.
2. Create two slicers one for both original and new column . Slicer with new coulmn will show same start and end ( Max snapshot date)
3. Create 2 bookmarks one to show first slicer and second to show original slicer. Default will be slicer with new column
4. Add a button ( Choose Custom Date Range), when user clicks on this it will show slicer with your main Snapshot date column.
5. Manage bookmark as per need ( like to have a button to close or move back) and you are done.
I hope it helps.
Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.
Cheers.
Neeraj Kumar