Drillthrough Cross-report in Power BI
Someone recently asked me: “If it’s possible to drillthrough from one report to another in the same Power BI workspace” Like hopping from one report to another related report housed in the same workspace. Voila! the feature is now available with the April 2019 Power BI Desktop Update.
Here is how:
- Update your Power BI Desktop to April 2019 Version
- Enable the cross-report drillthrough feature for both source and target reports on Power BI Desktop.
From File > Options and Settings > Options > Report Settings > Check the “Cross-Report drillthrough” Option.
3. Turn on the Cross-Report option under Drillthrough in the Visualization Pane for both Source and Target report .
4. Drag the field you want to use to drill cross the report, in this example I am drilling from Stores to Sales report. So, I am using “StoreLocation”
Note: For the drillthrough cross-report to work, this field “StoreLocation” must exist in both the Source and Target data models.
5. Publish the report to Power BI Service
6. Open the Target report in Power BI Service > right click on the store name you want to filter by and select Sales. For this example, I want to see Sales information for only Southwest location in Sales report.
7. To go back to the Source report, click the back button. The back button is created from Power BI Desktop using the report URL
Happy Dashboarding 🙂
3 thoughts on “Drillthrough Cross-report in Power BI”
Perfect!
Thanks for this great post. Is there a way to drill cross report in another workspace or an App?
Hi Eric,
For now you can only drillthrough cross-report to report that are in the same workspace or App.
OK thank you!
Comments are closed.