Drillthrough not working

[Anonymous]

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 "Jumbo", drillthrough does not appear!

Any help would be appreciated.

[v-qiuyu-msft]

Hi @Anonymous,

As we discussed offline, the issue is resolved now. I will close this thread. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft · Accepted solution]

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 

[Anonymous]

Solved my problem

[v-qiuyu-msft]

Hi @Anonymous,

Please follow this article to check if all settings are correct: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough. 

If issue still here, please send the pbix file to my work email. I will share it via private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

I have posted the ppix as you requested but have not heard anything

[v-qiuyu-msft]

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