Data and Analytics Resources

Provide Confident Assurance to Your Organization

Microsoft PowerBI Drill Through Reporting Has Arrived

by Will Crayger

Sep 20, 2017

The September update of PBI brings to us a slew of features, but the most notable has to be Drill Through Reporting capabilities. This has been one of the most sought after features among the PBI Community for quite some time, and I for one am beyond excited!

For those that are not familiar with this functionality, drill through reporting allows users to navigate from one report page to another, while passing through filters to the target page. Microsoft has also incorporated a “back” button, making navigating to the previous report page extremely simple. Having the ability to pass filter options from one page to another and quickly navigate back is a massive step in the right, and efficient, direction. 

Here’s a quick little demo and some instructions on how to set up your own reports:

Sector Comparison Report Page:
Sector Market Cap 1

Focus view of Sector Market Cap visualization:

  • Right click Technology > Drillthrough > Company Comparison Report
Sector Market Cap 2

Company Comparison Report (Filtered to Technology Sector):

Relative Market Performance Comparison 3

“Back” button on Company Comparison Report (Filtered to Technology Sector) used to navigate back to Sector Comparison Report:

Relative Market Performance Comparison 4

Focus view of Company Market Cap visualization:

  • Right click Microsoft > Drillthrough > Market Details and Close Price ForecastCompany Market Cap 5

Market Details and Close Price Forecast (Filtered to Microsoft Company):

  • Select the “back” button to navigate back to the previous report page, and again until you arrive at the starting page. 
Stock Market Trend Analysis 6

Setting up your reports for Drill Through is quite simple. Follow the steps below and you’re off and running.

1. You’ll notice a new option under the “Filters” section of your report field called “Drillthrough filters”. On the first target report page (the page you want to drill through to), place the field that you’re going to be using to drill. In my case, I will be using Company Sector as my first pass-through field.

Relative Market Performance Comparison 7


2. A "back" button will automatically be created for you. Position the button wherever you feel most appropriate. To navigate using the back button while in Desktop, hold CTRL and click. In Service, this is not necessary as you can simply click for navigation.

3. Repeat steps 1 and 2 for all consecutive pages in the drill path. For example, to drill through to the 2nd target page in my path, I placed Company Name on the 3rd page in my path. 

Amazon 8

4. That's it. You're all set. 

To view the full list of features in this month's release and to download Power BI, check out the official Microsoft notes here. For more insight into implementing Power BI into your business, contact CCG at info@ccgbi.com or (813) 265-3239. 


Leave a comment