Forum Discussion
Set default slicer to highest date in data set
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. ...
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