Forum Discussion
Automatically select the latest date in slicer (automated preselected slicer)
Hello, I have multiple reports in which new data extract is added each month. I am currently choosing the latest extract date in the extract date slicer so I can see only the last extract data. H...
Hi Anonymous ,
The Below video shows a way to get the latest date always by storing it to text and it is always selected. Do check if it helps in your case
https://www.youtube.com/watch?v=c_MjL1Cngbs
Regards,
Many thanks this actually works!
I also found another source that solves the issue with a similar way.
powerbi - Default slicer selection (latest date) in Power BI - Stack Overflow
PatChan
Helper I
Helper IHi,
I had the same requirement. In my case, I added the date field to the slicer, change filter type to "Relative Date" and choose "is in the last 1 year" and check "today" box. This ensures the latest dates are automatically selected without user having to manually drag to include the new dates.