Forum Discussion
Dynamic Date Offset Navigator
Hi AITGlobal
In the current implementation, the delta (number of days) is calculated dynamically from the selected date slicer range. Using a helper table and navigation controls, the report can shift the visible window one step forward or backward based on that delta.
However, bookmark-based solutions store static states, so supporting continuous multi-step navigation for any arbitrary user-selected range can be challenging with this approach without maintaining additional navigation state.
Hi AITGlobal
Thanks for reaching out to Microsoft Fabric Community Forum.
We have implemented the requested dynamic date offset navigator in the dashboard.
The system now calculates the delta (number of days) based on the current slicer selection and uses that as the window size. When you click Forward or Backward, the date range shifts by exactly that delta while preserving the original window size.
For example, if you select Jan 1–7 (7 days), clicking Forward moves the window to Jan 8–14, and clicking Backward moves it to Dec 25–31.
Attaching the PBIX file for your reference.
The current implementation allows forward and backward navigation only once. However, our requirement is to support dynamic multi-step forward and backward navigation without relying on bookmarks, as bookmarks are limited to static data. The solution should also function correctly for any user-selected date range.