Call bookmark while changing the Slicer

[Anonymous]

Hi All

There is an requirement that I want to call the boomark on the change of the Slicer. There are 2 bookmark and which need to call, it depend on the Slicer value.

My apporach is that firstly, we will call "Dataselected" event then "Get Slicer State".

I am facing challenge while picking the visual ID from the dataselected event. It will be great, if anyone did the same thing in the past and can provide the code for the same. It will great help of me.

Kind Regards

Ashwani

[Anonymous · Accepted solution]

Hi @Anonymous 

Power BI doesn't support to show or hide visual/bookmark based on slicer.

You can try my workaround.

Firstly build some different pages and hide other pages except of Home page.

Build a table named 'navigation' as below.

Build a slicer by Location column. Make sure that you have select Single Select in Format.

Build a measure:

Navigation Page = SELECTEDVALUE('navigation'[Location],"Home")

Build a Button, Select Page navigation Type in Action and add 'FX' Destination in Action.

Now you can go to different pages with different bookmarks by button and slicer.

Ex: Select Program in Slicer, and click Button.

We will go to Program page. In this page we can use Bookmark1 and Bookmark2.

Select Program Qol in Slicer and click Button.

We will go to Program Qol page. In this page we can use Bookmark2.

You can download the pbix file from this link.

For more details you can refer to this blog.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.