Forum Discussion
Power ParticipantSet most recent date as default to slicer
I have a slicer that contains "Calendar Weeks" and currently the most recent date in the slicer is 27 April 2020, and would therefore like this to be th default date when the report loads, obviously I could publish it with that date set, but then when the 04 May 2020 appears in the slicer, I would like that date to be the default, and so it always sets the most recent date in the "Calendar Week" column as the default for the slicer.
Is this possible?
6 Replies
blopez11Super User
Take a look at this post to see if it may be able to help you:
StuartSmithThanks, that link does look like it may help, but having trouble understanding how it works, etc. such as what to do or where to put the code..etc. was hoping for step by step instructions.
Can you remember how you got it working?
StuartSmith
In fact, there no straightforward way to select a category by default. As a workaround,You could add an additional slicer by creating a column, and select "the latest date".Lastest Date Slicer = IF(Table[Date] = MAX(Table[Date]),LASTDATE(Table[Date]))Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- StuartSmith
I figured out how to get the code working from the page https://powerpivotpro.com/2013/12/a-simple-trick-for-combating-stale-slicers/,
Latest_Date_Column = IF(Sheet1[Calender Week] = MAX(Sheet1[Calender Week]), "Latest", FORMAT (Sheet1[Calender Week], "DD/MM/YYYY"))And getting the "latest" displaying in the drop down, but the other dates are not in order. I guess it becuase its formatted as text. Any ideas how i can get the other dates in order?
You could use the format "YYYY/MM/DD" and it will orderning by default
