Dynamic selection in slicer data table

[Oliya]

Can I automatically select a value in the date slicer. If the data is for eg. till march 2022 then by default all the date should be selected till march 2022 and it will change based on the latest month.

[lbendlin]

- 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