Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Drill-Thru Two Tables

What is the best way to show one table as a summary and a 2nd table to show only the drill-thru results of a single # selected in the first table?
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

You can try to set up drillthrough filter on relationship column, then you can right click on visual who has fields from 'table 1' and select 'drill through' option to drill to table 2 and display related detail records.

Use drillthrough in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Drill-through works as expected, but how can I get it to show only the results of what I have selected?   Below, when I right click on "5" for Mike Siebert, and choose Drill-through, I would expect to see the result for only those 5 (e.g., On Schedule jobs).   Instead, it is showing all 8 line items, which are all of Mike's jobs.   

 

Result of drill-through

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    Maybe you can try to create unique key column(merge columns with primary fields and subfields) to store more accurate relationship keys, then you can use it to drill through more accuracy.

     

    Regards,

    Xiaoxin Sheng