Dropdown Slicer to Trigger Bookmarks in Power BI

[muhammedswaliha]

Hi,

I am building an IPL dashboard in Power BI Desktop. I have a "Records" page that contains two views:

• Batting Records (table)
• Bowling Records (table)

I have created two bookmarks:

• Batting View (shows batting table, hides bowling table)
• Bowling View (shows bowling table, hides batting table)

I want users to switch between these two views using a dropdown slicer, not buttons. For example:

User selects "Bowling Records" from dropdown → bookmark changes to Bowling View automatically.

Is there any way to make a dropdown slicer trigger or change a bookmark based on user selection in Power BI?

I know I can use two buttons to switch bookmarks. But I want a dropdown slicer because I may add more views in the future (3+ options), and buttons will take too much space.

Is this possible in Power BI? If not, is there any workaround?

Thank you.

[v-achippa]

Hi @muhammedswaliha,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Vinodh247 and @MFelix for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @muhammedswaliha,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[MFelix · Accepted solution]

Hi @muhammedswaliha ,

Taking into consideration your requirement I would suggest to have field parameters and not bookmarks.

With Field paramaters you can add all the columns and measures you want on  a specific view and then dinamically change the values.

In this case since you are using a table view you can create a Field parameter and add and additional column that categorizes those fields and then just use it on the slicer this will dinammically change your result without the need for additional visuals and configuration.

It's a scalable option and with low maintenance, if you want you can even make a excel file that will updated your field parameter in the future without the need to redo the Power BI desktop part again.

If there are fields similar in both options you can always add them on your table and then use the field parameters after those field because they work has a normal column or measure.

This is a simple example where I change the fields in the table showing the cost or sales columns that I selected in the field parameter.

Be aware that for the example I did not make the values to be correct is just to see the dynamics.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[Vinodh247]

Short answer: No, a slicer cannot directly trigger bookmarks in PBI.

PBI bookmarks are only triggered by buttons, images or bookmark navigator, not by slicers or filter selections. There is no native binding between slicer values and bookmark actions.

Recommended Workaround:
Instead of bookmarks, use a disconnected table + slicer + DAX + visuallevel filtering:

• Create a table like: View Selector = {"Batting Records","Bowling Records"}

• Add it as a dropdown slicer

• Create a measure: Selected View = SELECTEDVALUE('View Selector'[View])

• Use this measure in visual level filters:

  • Batting table -> show when "Batting Records"

  • Bowling table -> show when "Bowling Records"

    This approach scales cleanly for 3+ views and behaves like dynamic view switching without bookmarks. If you want a cleaner UX later, you can also look at Field Parameters, but for show/hide logic, the above method is the most practical.