Default filter

[Anonymous]

Hi All,

I want to create a slicer such as, whenever a user opens a report, it should be filtered to the latest date. Is there any way?

[lbendlin · Accepted solution]

This has been covered many times. Please use the search function.

In a nutshell:

- 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