Forum Discussion
Click & filter cross page
Hi there,
We got 2 pages in a project, both contains a map.
Is it possible to make:
When click on a country in Page 1 (all visuals are filtered on page 1), on Page 2, the same country is "selected" > then all visuals on page 2 are filtered base on the country?
Sounds like the slicer sync cross pages, but just apply on map selection.
Page1 click & selected USA:
not affected on Page 2:
Thanks.
H
Anonymous , Sync slicer is for the slicer. Drill through should help in this case
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Hi Anonymous ,
You must put drill-through field [country] in your page2. And when you right -click on the specified points in the map visual from page1 , you can drill-through to the page2 and the filter will works on the whole page in page2.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
4 Replies
Anonymous , Sync slicer is for the slicer. Drill through should help in this case
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
amitchandak, Unfortunately, I cannot see a "drill through" option after adding the field. (but i can see this option in other bar chart, don't know the reason)
On the other hand, there are other visuals on Page 2. The drill down may not reflect as "filter" function where a country is selected in Page 1, then on all visuals in Page 2 will show results for selected country on Page 1.
Thanks for your reply.
Hi Anonymous ,
You must put drill-through field [country] in your page2. And when you right -click on the specified points in the map visual from page1 , you can drill-through to the page2 and the filter will works on the whole page in page2.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you v-deddai1-msft , although this will make the map visual display single drillthrough country, and it does not support Multi-selected countries on map, but seems this is the only workaround.
Could you please let me know how to quick "clear" the drill-through? (Other than from "Visualizations") panel on right hand.
Possible to let user operate on the visual area?
Have a safe day.