Previous & Next Buttons

[bmar]

Hi everyone

I have a single - select drop down menu, but the drop down has ~1500 names, it's not user friendly to go to the next person. I'd like to include a next and previous button . I have created an index column to use +1/-1 to navigate through my list.

I have separate cards and a table that provides the current name, next name, and previous name, all currently showing the data correctly as I select random names in my drop down (in other words I have the correct DAX statements)

I attempted to do this with bookmarks - but because there are so many names and bookmarks are static, this is not a great avenue.

I attempted to do this with page navigation but it doesn't leverage the logic from my measures or calculated columns. It works in the sense that it toggles between previously tested names.

I am now attempting to click on the name from the table in hopes that the next/previous name may update the slicer

Has anyone come across this exercise before?

[Anonymous]

Hi @bmar ,

Whether the advice given by AllisonKennedy  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[AllisonKennedy]

@bmar  I love the idea of prev/next buttons but my brain can't currently work out how to achieve it.

You could have a slicer that lets the user pick the page number, and that will limit what names are shown in the drop down. They'll still need to pick a new name, it's not as seamless as just clicking the next button. 

I've mocked this up using Year and Month/Year, where Year is the page number and month/year is the name list in your case: 

To get it to work, you need to edit interactions on the slicers to turn off interactions for the PageNumber slicer when something is selected in the name slicer. 

otherwise, as you say, using bookmarks is very static, so you'd need to create a bookmark for each page, similar to this post here: Power BI – How to do Pagination in Power BI Reports - FourMoo | Fabric | Power BI