Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I need to create a drill-through between two tables, joined by many-to-on relationship. The master table contains the "many" records, while the "detail" table contains single row with lot of attibutes.
After applying the join column as the drill-through column, the "detail" table always shows all the existing records, it simply does not filter by the drill through value
If I change the roles, if I want to do a drill through from the second table on to the first, based on the same column, the drill through works perfectly, it shows the expected rows, the ones that fullfill the drill through filter.
Any ideas what I might be doing wrong?
Thanks
Viktor
Solved! Go to Solution.
Thanks Amitchandak for the quick reply. Actually, the join was fine, but after double-and triple checking I found the problem (or at least I found a solution that works for me 🙂 )
If the cross-filter direction is set to "both" then the drill through works as expected.
Thanks
Viktor
@Anonymous , I doubt the link column in visual and link column is table is not same. Some join problem.
Can you share data model?
Thanks Amitchandak for the quick reply. Actually, the join was fine, but after double-and triple checking I found the problem (or at least I found a solution that works for me 🙂 )
If the cross-filter direction is set to "both" then the drill through works as expected.
Thanks
Viktor
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |