Forum Discussion
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 "Jumbo", drillthrough does not appear!
Any help would be appreciated.
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
6 Replies
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 YuHi 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 YuHi 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 YuHi Anonymous,
As we discussed offline, the issue is resolved now. I will close this thread.
Best Regards,
Qiuyun Yu