Forum Discussion
Helper IVA button which should work like a slicer
Hi all,
I need a guidance for making a visual. I have a 100 rows of data having vessels related imformation. I want to show this in a matrix visual one vessel at a time. I want a next button which should filter the data and give me the next vessel related information when clicked.
Below image, i tried by adding a parameter and having single select in the slicer, but here we need to navigate to the left and right then click on the number. I want the moment we clieck of next or previous the data should change in the table below.
Hi,
Yes, bookmarks save the state of the report, including the slicer value, so if you create a bookmark while vessel 1 is selected, that bookmark will always return to vessel 1, so in practice you would need multiple bookmarks, one for each vessel, each bookmark storing a different slicer value, and the buttons would point to those bookmarks.
Because of this it does not scale well with many vessels, since Power BI cannot automatically increase the slicer value with a button, for many vessels it is usually easier to use a slicer.
You’d need over a hundred bookmarks because each item requires its own view with Previous and Next buttons linked to separate bookmarks. This approach isn’t scalable and would be a maintenance nightmare. The closest out of the box solution is the Play Axis visual.
7 Replies
- DanieleUgoCopp
Super User
Hello,
Power BI does not have a real next or previous button for slicers, so it cannot automatically move to the next vessel, but I think you can use a simple workaround.
Create an index for the vessels from 1 to 100, you can do it in Power Query or with DAX, then create a slicer using that index with single select, connect the index to your vessel table so the matrix shows only the selected vessel.
For navigation you can create two buttons, Next and Previous, using bookmarks that change the slicer selection, when the slicer changes the matrix updates and shows the next vessel.
Best regards,
Daniele
Rahul_SCDanieleUgoCopp , thanks for responding.
But, I am not sure how the bookmarks would change the slicer.
Are you suggestion to create 100 booksmarks if you have 100 vessels to show and link each of the booksmarks with each vessel to view?
Thanks.- danextian
You’d need over a hundred bookmarks because each item requires its own view with Previous and Next buttons linked to separate bookmarks. This approach isn’t scalable and would be a maintenance nightmare. The closest out of the box solution is the Play Axis visual.
- DanieleUgoCopp
Hi,
Yes, bookmarks save the state of the report, including the slicer value, so if you create a bookmark while vessel 1 is selected, that bookmark will always return to vessel 1, so in practice you would need multiple bookmarks, one for each vessel, each bookmark storing a different slicer value, and the buttons would point to those bookmarks.
Because of this it does not scale well with many vessels, since Power BI cannot automatically increase the slicer value with a button, for many vessels it is usually easier to use a slicer.
- cengizhanarslan
Power BI buttons cannot directly change a slicer value dynamically, so a true Next / Previous record navigator is not supported. You wouls always need to select the value from the slicer after you click right/left buttons that you show.
Hi Rahul_SC
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi Rahul_SC
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
