Slicer

[Ahoupt08]

We use a slicer for date ranges on almost all of our dashboards. The biggest pain is the date range does not automatically update when the dashboard auto refreshes daily. We have multiple reports on our dashboards and use a slicer for date range on all of them.

If this helps, we use the Slicer 'Style' option "Between". 

[v-yueyunzh-msft · Accepted solution]

Hi , @Ahoupt08 

If the date table is dynamic, the "between" date slicer can be dynamically updated to most recent date.

Here is a example, if i create a date table as below:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[lbendlin]

Remember that slicers observe a "default"  value, and they also support relative dates. The latter is the preferred option.  Set it to "Last 14 days"  for example.

If you want to go for the "Default" pattern:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app