Forum Discussion
DrillThrough filter direction
Hello,
Testing drillthrough behavior in Power BI and wanted to confirm something with the community 👇
Setup:
Source page → visual built on fact table (Fct_EA_AmortizedCosts_Daily)
Target page → visuals built on dimensions (Dim_EA_AmortizedCosts_Resources)
Relationship → 1:* (Dim → Fact, single direction)
Drillthrough field → SubscriptionName
Drillthrough here = passing selected value (e.g. SubscriptionName) from source visual as a filter to the target page.
Observation:
Even though the source comes from FACT and target visuals use DIMENSIONS, drillthrough works fine with single direction (Dim → Fact).
So question:
Does filter direction actually matter for drillthrough?
Best,
Jacek
The filter direction is treated the same on drill through pages as on any other page, what is happening here is to do with expanded tables ( https://www.sqlbi.com/articles/expanded-tables-in-dax/ ).
If you have measures on the drill through page which use the fact table as a filter argument that would explain what you're seeing. The drill through filter is applied to the expanded fact table which includes all the columns of the dimension table, so only the relevant rows of the dimension table are visible.
2 Replies
The filter direction is treated the same on drill through pages as on any other page, what is happening here is to do with expanded tables ( https://www.sqlbi.com/articles/expanded-tables-in-dax/ ).
If you have measures on the drill through page which use the fact table as a filter argument that would explain what you're seeing. The drill through filter is applied to the expanded fact table which includes all the columns of the dimension table, so only the relevant rows of the dimension table are visible.
Hi jaryszek,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to johnt75, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member johnt75, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
