Forum Discussion
Solved
Auto Update Start Date in Slicer
I have a report that has information for services scheduled. The data pull has data starting from 2020 through future dates. When the data set refreshes, is there a way to have the start date in the ...
Use the Relative Date filter option in the Filter Pane, or create your own default.
- 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
lbendlin
Super User
Super UserUse the Relative Date filter option in the Filter Pane, or create your own default.
- 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