Forum Discussion
How to keep bookmarks updated when data in dropdown slicer changes?
v-angzheng-msft sirlanceohlott AllisonKennedy
Hi,
Below is my dataset
I have two pages. The 1st Page has Price details of each of the fruits being shown in a Gauge Visual for each fruit. On the filter pane, Fruit_id is used as a filter to show the price.
On the second page details of 1 selected fruit are shown.
To Achieve Navigation from the 1st page to the 2nd Page, I have created transparent button and placed it on top of the Gauges.
On the 2nd Page, from the dropdown slicer I selected a Fruit_Name and created a bookmark. I have assigned this bookmark navigation as the action of the button on the 1st Page.I Repeated this for all the fruits.
Now, If the data changes say, id 3 – Papaya is replaced with Sweet Lime, the Navigation will happen however there will be Papaya selected which actually is removed and no data will be visible.
In this case I manually have to recreate the Sweet Lime bookmark or update the existing Papaya Bookmark.
Is there any way I can use Fruit_id to create the bookmark and not show the id on the page while still keeping the dropdown slicer on Fruit_name?
I tried using Filter Pane with Fruit_id to create the bookmark, however once data is changed, Papaya is selected and Sweet Lime appears as another menu option.
Any help on this will be highly appreciated.
Thanks in advance
21 Replies
- MFelix
Super User
Hi Anonymous ,
In this case you should use the drilltrough option and not the bookmarks:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
This will allow to keep the filter context based on the fields you select for the drilltrough, then this can be assined also to a button.
Hi MFelix ,
I am using guage visual.
Drillthrough is not available as an option for this visual.
Thanks
- MFelix
Hi Anonymous ,
The drill trough options is available for all visuals, if you use the metric that you use on the Gauge chart on the drill trough page you will be abble to make it.
Has you can see below the gauge is filter to a single Level selected:
The detail has several levels:
When I place the Measure that I'm using on the Gauge chart has a drill trough:
It get's available on the Gauge chart and returns correct result.
If you have more measure to use in the drill trough you can place them all. (This also works for cards and similar visualizations).
- bcdobbs
Community Champion
Can you supply a demo pbix file?
Hi,
Below is my Page 1 –
Here I have a Gauge for each Fruit
To Make each gauge show price of One Fruit, Fruit ID is mapped in the Filter Pane.
On top of these gauges are transparent buttons placed. These buttons navigate to the specific Bookmarks.
Refer below Page 2 and the Bookmarks Pane –
Since Bookmark here is created on the Fruit Name Slicer, if the fruit name is changed, this bookmark will not show any data.
I am looking for ways to keep the visualization as it is but using Id to create bookmark such that even if the fruit name changes, it does not have an impact on the visualization
Thanks
++ PhilipTreacy v-kkf-msft zhouguyin Anonymous Payeras_BI
- AllisonKennedy
Anonymous , MFelix has good suggestion, otherwise can you use Fruit Name in the filter pane instead of Fruit ID?
- MFelix
Hi AllisonKennedy,
The question is exactly that. The name cannot be used on the filter because it can change and then break the filtering so needs to be by ID.
