The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
What you're trying to achieve with a "Next" and "Previous" button functionality for a dropdown with 1500 names can be done using DAX measures and Power BI's visual interactivity, but there isn't a direct way to modify a slicer selection via buttons. However, you can create a navigation mechanism that updates your report visuals without directly modifying the slicer itself.
You've already created an index column, which is great! This will be used to navigate between names.
For example:
Alice | 1 |
Bob | 2 |
Charlie | 3 |
You'll need DAX measures to determine the current, next, and previous names based on the selected name. You might already have this part working, but here’s how you can structure it:
Current Name:
Next Name:
Previous Name:
Power BI doesn't have native "Next" or "Previous" buttons that manipulate slicers, but you can simulate the behavior using Bookmarks, DAX measures, and Selection Pane:
Next Button:
You won't be able to directly change the slicer’s selection, but you can dynamically update visuals (e.g., Cards, Tables) that display the next name.
Previous Button:
Rather than trying to directly interact with the slicer, you can have visuals (such as cards or tables) display the current, next, and previous names based on the measures. Clicking "Next" and "Previous" buttons can update these visuals.
If you need more interactivity and flexibility, consider using a custom visual, such as a table or slicer visual that supports more advanced interactions. You could dynamically filter the data based on the measures for current, next, and previous names and update the report content accordingly.
Here’s a way to create visual buttons with a conditional action:
Power BI doesn't support directly modifying slicer selections programmatically, so the most feasible way is to build your navigation system through measures and interact with the visuals via buttons and DAX logic.
This approach gives the user a similar experience as navigating through names using buttons without needing to interact with the slicer directly.
Hi, I know this is an older post, but I'm replying hoping I can get some clarity on the solution above. I'm trying to add PREV / NEXT buttons to move to the next row of the data table in my visual. I've completed Step 2 and created the DAX measures, but I can't figure out how to format the button to trigger these measures. Could you expand on Step 3? Thank you so much!