Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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