Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |