Dropdown Slicer to Trigger Bookmarks in Power BI

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