Forum Discussion
Default filter
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?
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
1 Reply
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