Forum Discussion
Drill through Option doesn't Appear
Hi All,
I have 2 different .pbix files. One is a summary level report and the other one is a detailed report. The purpose is once the user clicks on one of the data points it will take the user to the detailed level report. I got it working by following the below link
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
I published both of the reports to the service and they are working fine in the service. For some reason when i click on the PBI Desktop for the Summary report i do not see the drill through option any more. Please see the attched screen shots, the first one is for the PBI Service and the second one is for PBI Desktop.
Also is there a way i can create a drill through from a Graph report to the detailed level report?
Thanks
Hey Anonymous ,
drillthrough between different reports only works in the service, this is the reason why you will not see the action in the context menu inside Power BI Desktop.
As a chart is "just" another representation of one or more data points, you can use a chart as the starting point as well:
Hopefully, this provides the answers you are looking for.
Regards,
Tom
3 Replies
- TomMartens
Super User
Hey Anonymous ,
drillthrough between different reports only works in the service, this is the reason why you will not see the action in the context menu inside Power BI Desktop.
As a chart is "just" another representation of one or more data points, you can use a chart as the starting point as well:
Hopefully, this provides the answers you are looking for.
Regards,
Tom
TomMartens thanks . Please see the below screen shot, i do not see the option for the graph in PBI Service.
- TomMartens
Hey Anonymous ,
you have to enable the option in the source report, the report that initiates the jump to a target report:
then the option to drill through will appear in the source report
Here you will find an article that describes the setup much more detailed:
Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Docs
Hopefully, this provides what you are looking for.
Regards,
Tom