Forum Discussion

Craig_Harley's avatar
Craig_Harley
Regular Visitor
4 months ago
Solved

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 n...
  • Juan-Power-bi's avatar
    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.