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).
Hi Anonymous - you can create a seperate dim table and load it to your model related to table a and table b.
Power BI considers them as distinct lineages,even if you use a UNION in a view and a source_table column, if the drill-through visual uses fields from the original tables, it won’t match the combined field in your target page.
add, use a slicer or page-level filter on source_table to isolate which records should appear on the target page.
Hope this helps.