Forum Discussion
Nested Drill throughs
Hi phoisan ,
You may need to select a single data point from product ID in the Product Info page, then click the "Sales" or "Return" button to the destination page.
For reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons
https://www.youtube.com/watch?v=IEYo7zUYCgY
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi phoisan
The drill-through filters are passed at the time when you initiate the drill-through to that specific page, so if you are using navigation buttons it will not work.
However, you can use a visual in your drill-through page to initiate drill-through to another page or you new capability of drill-through buttons as per below.
https://www.youtube.com/watch?v=hXyrROrSy2A
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi Mariusz
The button I setup is drill through button.
When I drill through to second level of child page, it did not reflect the first level child (its parent) product id.
Product list - Main Page
Product Info - drill through page (based on product id selected in main page) - First level child
Product sales - drill through page (based on product id selected in main page) - Second level child
Product return - drill through page (based on product id selected in main page) - Second level child.
I select product id from "Main Page" and drill through to "Product Info" page. When I click the "Product sales" button and "Product return" button ( drill through button), it can drill through to the correct page but wrong product id. Everytime I need go back to the main page and drill through to other pages in order to reflect correct product id.
Is there any solution to pass the product id from first level child page to second level child page?
Thanks
