Forum Discussion
Nested Drill throughs
Hi,
I'm new to Power BI. I'm trying to set up a nested drill through but no success.
I have a main page and three drill-through pages
Product list - Main Page
Product Info - drill through page (based on product id selected in main page)
Product sales - drill through page (based on product id selected in main page)
Product return - drill through page (based on product id selected in main page)
When I drill through to Product info page, there are two button to drill through to other pages. Button "Sales" which use to drill through to to product sales page and "Return" to product return pages.
When I click on the sales button, it navigate to product sales page but did not reflect the correct product ID which selected at Product info page.
Everytime, I need go back to main page and drill through every pages in order to reflect the selected product id.
Is there any way to only select one time product id at main page, and all other detail pages reflected to selected product id data?
Thanks
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.
4 Replies
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=hXyrROrSy2ABest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInHi 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
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.
Yes, have to use single data point to drill through.
