- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Create button to move forward and backward through CONSECUTIVE months in Power BI Desktop
Hi,
I'm looking for a way to create buttons which allow my endusers to move forward or backwards through consecutive months. I'd like to have ONLY ONE forward button and ONLY ONE backward button and the option the press them multiple times and thus move over the months in the required direction, one month at a time.
For instance: assuming the current monthnumber is 7, pressing the forward button once should update the current month to 8 and pressing it once more should update it to 9.
I've tried this out using bookmarks, but I cannot figure out how to allow a usecase where the buttons are pressed multiple times in order to move backwards of forwards multiple months.
Any ideas on how this can be achieved ?
I appreciate your help.
Kind regards,
Cees
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @cvdiermen , Unfortunately functionality you’re looking for—buttons that dynamically allow navigating to the next or previous value in a slicer—is not fully supported in Power BI
PFA Community Links:
Buttons to go back months and forward in months in power bi
Select the Next or Previous value in a slicer
But you can use the Back button to return to the previous page of a report. You can also use DAX to work with periods in Power BI
If I have resolved your question, please consider marking my post as a solution. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thnks a lot for your prompt reply. I thought i was missing something obviuos, good to know it's simply not there (yet).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @cvdiermen
Just offering a possible option you may want to experiment with:
There is a custom visual created by @mprozil that is available on her GitHub repository called D-Pad.
As far as I can tell it's not in the AppSource store yet, but you can download the file dPad.pbiviz from the Dist folder in the repository.
https://github.com/mprozil/dPad/blob/master/dist/dPad.pbiviz
You can then import the D-Pad custom visual into a Power BI report and set it up to "scroll" left and right through values of a column such as Month.
One potential issue is that the D-Pad visual doesn't appear able to retain its state in the way other filters do, so it always begins from an unfiltered state when the report is opened.
Sample PBIX attached.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @cvdiermen , Unfortunately functionality you’re looking for—buttons that dynamically allow navigating to the next or previous value in a slicer—is not fully supported in Power BI
PFA Community Links:
Buttons to go back months and forward in months in power bi
Select the Next or Previous value in a slicer
But you can use the Back button to return to the previous page of a report. You can also use DAX to work with periods in Power BI
If I have resolved your question, please consider marking my post as a solution. Thank you!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
03-28-2024 06:16 AM | |||
04-01-2023 11:25 AM | |||
07-11-2023 10:03 AM | |||
02-22-2024 04:12 AM | |||
08-28-2023 04:13 AM |
User | Count |
---|---|
86 | |
72 | |
55 | |
39 | |
38 |
User | Count |
---|---|
95 | |
63 | |
56 | |
48 | |
46 |