Forum Discussion
Dynamic Date Offset Navigator
I am working as Power BI Developer and I am currently working on dashboard. In which I am stuck with one issue, the problem statement as below "Implement a Dynamic Date Offset Navigator that allows for iterative time-shifting. The system must calculate the 'delta' (number of days) of the current slicer selection and provide 'Forward' and 'Backward' buttons. Each click should shift the date window by that delta—allowing users to move incrementally through time (e.g., jumping from Week 1 to Week 2, then Week 2 to Week 3) while maintaining the original window size.".
Dashboard is already developed and this new request we have received. Whta wiull be the solution for it not updating any dax and and not changing any relationship
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.
6 Replies
v-aatheequeCommunity Support
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.
- v-aatheeque
Hi AITGlobal
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.- v-aatheeque
Hi AITGlobal
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
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.
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.
- v-aatheeque
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.
