Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
phoisan
Helper I
Helper I

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

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
v-xicai
Community Support
Community Support

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. 

Mariusz
Community Champion
Community Champion

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

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

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

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.