Forum Discussion
Decomposition Tree Drillthrough issue
- 4 months ago
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.
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