Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
27 | |
3 | |
2 | |
2 | |
2 |