Forum Discussion
Problem - Slicer Date (multiple selection) by default last day
Hi Elisa_Costanza ,
You cannot have this directly, you need to create a new column (using Power Query or DAX calculated column) with the value for the current date saying today so your data on that specific column will look like:
Today8/20/2025
8/19/2025
8/18/2025
...
1/1/2025
Then do a sort of this column by the date column so you have the correct sorting, then use this specific column on your slicer and select the Today value before publishing that will force the value to always be the default one.
The rest will work in the same way.
Hi Elisa_Costanza ,
You cannot have this directly, you need to create a new column (using Power Query or DAX calculated column) with the value for the current date saying today so your data on that specific column will look like:
Today
8/20/2025
8/19/2025
8/18/2025
...
1/1/2025
Then do a sort of this column by the date column so you have the correct sorting, then use this specific column on your slicer and select the Today value before publishing that will force the value to always be the default one.
The rest will work in the same way.
Thank you so much š it works. I would have preferred to see the latest date directly in the format 22/08/2025, but it seems to be the only possible solution for the moment..
Thank you MFelix š