Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 slicer automatically update to the previous days date?
Example: Data set refreshes on 5/9/2024, start date in slicer should be 5/8/2024. We still need to be able to manually adjust the start day to a past date if we need to analyze historical data.
Solved! Go to Solution.
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
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
User | Count |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |