Forum Discussion

eyeekit's avatar
eyeekit
Frequent Visitor
2 years ago

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. Any help is much appreciated...

 

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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