Forum Discussion
Decomposition Tree Drillthrough issue
Hi,
I am relatively new to Power BI and have been trying to Drillthrough from a Decomposition Tree
I can Drillthrough successfully, however the number of items listed on my Drillthrough page does not match the number identified on the Decomposition Node.
In the example below
If i drill through from Product under the ESM Data Group I get the correct result and have 10 entries shown within the Drillthrough page
However If i drilllthrough from Product Feature under ESM Entity or if I drillthrough from any of the entries under API URI, I still get 10 entries displayed on my Drillthrough page (i.e. everything under Product (ESM Data Group).
Apologies if I am missing something obvious here, any help or guidance would be very welcome
When you drill through from a deeper node (like Product Feature or an API URI value), the Decomposition Tree only passes the currently expanded node's filter context to the drill-through page — but it doesn't automatically pass all the parent-level filters above it in the hierarchy.
So when you drill through from an API URI node, the drill-through page receives a filter on that specific API URI field, but it doesn't know to also filter on the parent Product Feature or ESM Entity values that were constraining it in the tree. This is why you end up seeing all 10 records from the Product level instead of just the subset visible at the deeper node.
The workaround is to make your drill-through page aware of all the relevant dimension fields from the tree. Add the API URI, Product Feature, and ESM Entity columns as drill-through fields on your destination page. The Decomposition Tree should then pass the selected node's value along with its context more completely.
If that still doesn't work as expected, an alternative is to use the "Pass all filters" option in the drill-through settings on the destination page — this tells Power BI to carry over the full filter context rather than just the explicit drill-through field. Check your drill-through page settings and make sure "Keep all filters" is enabled.
4 Replies
When you drill through from a deeper node (like Product Feature or an API URI value), the Decomposition Tree only passes the currently expanded node's filter context to the drill-through page — but it doesn't automatically pass all the parent-level filters above it in the hierarchy.
So when you drill through from an API URI node, the drill-through page receives a filter on that specific API URI field, but it doesn't know to also filter on the parent Product Feature or ESM Entity values that were constraining it in the tree. This is why you end up seeing all 10 records from the Product level instead of just the subset visible at the deeper node.
The workaround is to make your drill-through page aware of all the relevant dimension fields from the tree. Add the API URI, Product Feature, and ESM Entity columns as drill-through fields on your destination page. The Decomposition Tree should then pass the selected node's value along with its context more completely.
If that still doesn't work as expected, an alternative is to use the "Pass all filters" option in the drill-through settings on the destination page — this tells Power BI to carry over the full filter context rather than just the explicit drill-through field. Check your drill-through page settings and make sure "Keep all filters" is enabled.Go to your drillthrough destination page, then, in the Filters pane on the right, under Drillthrough, add all three fields: ESM Data Group, ESM Entity, and API URI as drillthrough filters.
Hi Craig_Harley ,
Thank you for reaching out to the Microsoft Community Forum.
Hi Juan-Power-bi and cengizhanarslan ,Thank you for your prompt responses.
Hi Craig_Harley , could you please try the proposed solutions shared by Juan-Power-bi and cengizhanarslan ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Thank you Juan, that worked a treat 😊
