Forum Discussion
Helper IVDrill Through among different pages
Hello Hello Community!
I am struggling with the Drill-Through experience...
I want to drill through a main page MAP (with countries) and that drilling into a country i takes me to differents pages related with navigation experience.
Main page MAP, then after selecting a country 3 pages filtered by the selected country and i move among these pages with navigation botton
Duplicating the pages doesn't work, using markdown would be an option but very heavy to develop...
Thank you in advance!
Hi, Quentin
I think I fully understand your needs, and I have also made some attempts. You want to navigate to other pages without using the drill through field but still save the filtering effect. This is really difficult to do, because powerbi currently doesn't have a good support for dynamic interaction between different pages.
If you don’t mind, I have a workaround here.
1.Don't need to use drillthrough, but you need to select a country on the first page, and then click the button to jump to other pages.
2. You need to set up a synchronous slicer, and then only keep one slicer on the first page, and hide the others. In this way, you only need to make one more choice in the first step, and the data on other pages will have a filtering effect.
Like this:
Reference:Sync and use slicers on other pages
If you still need help, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 Replies
- amitchandak
Super User
Quentin , The information you have provided is not making the problem clear to me. Can you please explain with an example?
Appreciate your Kudos.
QuentinSorry that i didn't manage to make it clear, and thank your for answering
I have a main page with a map:i want the user to select the country he wants to drill through and this take him to a page that has been filtered by the country:
But this page called "Country-Detail" just have a sumary of the data, i want the user to be able to open other pages that deploy more information about one part of the indicator.
I was using the navigation botton to open a new page, for example the first box "i" botton at the nivel of the "Country-Profile" Indicator:
As you can see the country stay the same than when i duplicated the drill page.
Filtering by a country in the map, filter the Country Detail page, but do not filter the pages that provide more information...
- Quentin
I did it with Bookmark:
I create the page i want to navigate to, group everything including a white layer beyond into a group and copy paste the group in the first Drilled-Through Page so that the page filter stay the same
It is not the solution i was looking for but work... is it possible though to do what i wanted?
Thanks - v-janeyg-msft
Community Support
Hi, Quentin
Drill through can be done in two ways, buttons and fields. They can be used flexibly, but you need to set the target page yourself.
Here are some tutorials for your reference:
Set up drillthrough in Power BI reports - Power BI | Microsoft Docs
Power BI Drillthrough Tutorial | Step by Step Guide with Examples (wallstreetmojo.com)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Quentin
THe problem i have is to make a drillthrough with multiple target pages...
- v-janeyg-msft
Hi, Quentin
I think this is not a conflict, you need to set up multiple drillthrough pages separately. Where did you have the problem?
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
