Forum Discussion
Create button to move forward and backward through CONSECUTIVE months in Power BI Desktop
- 1 year ago
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!
Thnks a lot for your prompt reply. I thought i was missing something obviuos, good to know it's simply not there (yet).
- OwenAuger1 year agoSuper User
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