Forum Discussion
Drill-through Not Working Between Pages Using Different Data Sources in Power BI
Close to the solution, Make only one relationship active at a time.
In your model view, keep the relationship from Dim_table → TableB active.
Keep the Dim_table → TableA relationship inactive (unless you need it for measures).
Check below :
1.Visuals on the main page are from Dim_table
2.Visuals on the target page are from TableB and Dim_table.
3.This ensures filter propagation flows cleanly during drill-through from Dim_table to TableB.
this works, Ensure your drill-through filter field is the same field used in the relationship (i.e., KeyColumn from Dim_table).
Anonymous Hey,
Steps to follow
1) Create a combined table in power query
something like below
SELECT *, 'SourceA' AS source_table FROM TableA WHERE Rank = 1
UNION ALL
SELECT *, 'SourceB' AS source_table FROM TableB
step 2- Use only field and drill thorough filters from your newly union table for drill - through - This will only work if visual and drill thorough page from same table
step 3 - add a page level filter from on drill through page
Thanks
Harish KM
Please accept this as a solution if this solves your problem and give kudos as well.