Set the date slicer to be the most current date

[Anonymous]

I have a date slicer (please see below). I would like to always have the most recent date selected. So when the user opens the dashboard, the slicer must be filtered with the most recent date. At this time, it should have January 2020 selected, but when the data refreshes at the end of this month, it must have February 2020 selected. This must be done automatically, any thoughts how this could be achieved?

[dax]

Hi @Anonymous , 

You could try to use slicer ->relative date to see whether it work or not.

You could create a calendar table for slicer , then set it like below to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This works, but then I can't see all my other dates as it only shows the one within 30 days and not my dates from 2018 and 2019.

[dax]

Hi @Anonymous , 

If possible , could you explain this to me in details? Did you mean you want to show last 30 days based on today? Or other requirement? Could you please inform me your expected output? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @Anonymous ,

Can you share some screenshots on how is the current date slicer look and what is the intended functionality?

I also found an article below that helps in achieveing this:

https://businessintelligist.com/2016/04/15/power-bi-tutorial-dynamically-update-date-slicer-to-show-current-date/

Thanks,

Pragati

[Anonymous]

Hi @Anonymous,

This thread sounds similar to what you're looking to achieve:

https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442

Thanks,

Andy