Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Drillthrough not working

I have a summary page and a detail page.  Both pages have a field called "Jumbo" (a sku).  On the detail page I put "Jumbo" in the "DRILLTHROUGH" section.  On the Summary page, if I right click "Jumb...
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous,

     

    After looking into your pbix file, the column you put in the Drillthrough filter pane on detail page comes from table JumboRM, while the table visual you would like to perform drillthrough comes from another table Jumbo. Please remove original Jumbo column in Drillthrough filter pane, drag the Jumbo column from Jumbo table to Drillthrough filter pane. In this way, the drillthrough button is available when we right click on the value in summary page. 

     

    As table visual in summary page and detail page comes from different page and there is no relationship, in order to ensure filter is working via the drillthrough action, we need to create a relationship between these two tables. 

     

    Please double check this article to know more information about how to use drillthrough feature: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough. I will send your updated pbix file. 

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
7 years ago

Hi Anonymous,

 

Does the issue happen in Power BI desktop or service? If it's possible, please share the pbix file with us. You can upload it to your OneDrive and send the link to me via private message. 

 

Also you can test with our report which works fine on our side to see if the same issue happen. 

 

Best Regards,
Qiuyun Yu