Dynamically change a drill through ?

[EaglesTony]

Hi,

  I have 2 pages.

  Page 1 has Parent, Page 2 has Child (Page 2 has the drilldown based on the Parent ID).

  Is there a way on Page2 to have a button or some logic to clear out the drill through to see all the Children(regardless of who the parent is) and then also a button or process to "repopulate" the drilldown field with the Parent ID ?

[Anonymous]

Thank you @amitchandak 

Hi, @EaglesTony 

At the moment it may not be possible to do the point you mentioned directly, or you can try the point made by Super user.
In addition, there is another way to do this:
First I have a page1 that can drilthrough to page2:

We were able to find the point where Page2 applied our drillthrough again. To clear the filter effect, we can copy the current page2 and clear the drillthrough field:

Add a navigation button to page2 and select the target page as a duplicate page:

Copy this button to the copy page:

When I click on these two buttons, I can toggle between the clear filter you mentioned and show all project status. If you're worried about the current page being seen, you can also hide it for a seamless transition.

Best Regards

Jianpeng Li

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

[amitchandak]

@EaglesTony , Based on what I got. You need a partial drill-through.  In that case, you can un-check the keep all filter and keep only what you need

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

You can use measure in drill through button to switch pages

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons