Forum Discussion
Need help with missing drill through option
Hi All,
I do not see the drill through option on any of my reports. I have a report with multiple pages. I have a Page (this page has multiple graphs that use different datasets, however this one scenario is related a graph that shows the counts by week). The other tab has the counts by each day . I have the same dataset ( direct query) . I have the same filters on both the tabs (year and weekofyear). The main report has the "crossreport" turned off, the target report has the "crossreport" turned on. I added the (year and weekofyear to the drillthorugh fields on the target tab). On both the tabs in option>currentfile>reportsettings i checked the crossreport box. I went through many links posted here, i downloaded the latest version and still i cannot see the drillthrough option. Please advice.
Thanks
Hi Anonymous ,
By my test with the latest version of Power BI desktop, I cannot reproduce your issue.
Here is my test output.
You could refer to my test pbix which has been attached.
If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
8 Replies
Hi Anonymous ,
By my test with the latest version of Power BI desktop, I cannot reproduce your issue.
Here is my test output.
You could refer to my test pbix which has been attached.
If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
Thanks v-piga-msft, yours show tables , mine is a graph does that make a difference? This is really insane when i opened the powerbi desktop it asked me to update and when i did , now i cannot see the cross report option , i clicked on options and current file report settings i do not see the cross report option. this is getting really weird, why should i update, why do i get the pop up to update and i ignore the pop up the reports not showing any data. st@#$$%t tool ever
Hi Anonymous ,
Firstly, I'm afraid that the Cross-report option will not affect the drill through by my test.
In addition, what's version of power bi desktop currently?
Besides, you just share the sample pbix which could reproduce your issue, you could mask your sensitive data before uploading.
Best Regards,
Cherry