Set default slicer to highest date in data set

[eyeekit]

Hi,

i have a date slicer with some (random) date values.

How can I achieve that when opening the report the default is set on the maximum value? 

Easy question but i don't seem to get it done. Any help is much appreciated...

[lbendlin]

Here is the default approach. Adjust as needed.

- 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