Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Setting Up a Drillthrough Action in your Power BI Report

  • 2 September 2017
  • Author: DustinRyan
  • Number of views: 4454

At some point this weekend, the Microsoft Power BI folks turned on the drillthrough feature in the Power BI service. This is the same drillthrough feature that demonstrated during day 1 of the Microsoft Data Insights Summit, which you can read about here. So I thought it’d be good to quickly walk through how you can set up the drill through action.

First, navigate to a report that you’ve already published to the Power BI service. This report will become the target of your drill-through action. Start editing the report and you’ll notice that on the right side there is a Drillthrough Filters section.

power bi drill through action

This is where you add fields that will be used to invoke the drillthrough action. I’m going to add the Subject field to the drillthrough filters section, like so.

power bi drillthrough filters

Once you add the field to the Drillthrough Filters section, a small back arrow will be added to the report to allow you to easily go back to the report page you used to invoke the drillthrough action.

power bi drillthrough action go back

And that’s pretty much it. Now you can invoke the drillthrough action on any page in the report. To invoke the drillthrough action, right-click a chart that uses the field you added to the Drillthrough Filters section, select Drillthrough, and then select your report. I selected the Life Skills bar in the bar chart and then selected my Drillthrough action.

Power BI drillthrough action

This automatically takes me to the Subject Dashboard, the target of my drillthrough action, with the correct filter applied, as seen below. My report automatically is filtered to the Life Skills subject!

power bi drillthrough action

Keep in mind that configuring the drillthrough action is not possible in the current release of Power BI Desktop, but I’d be willing to bet that we’ll see this functionality appear in the next release of Power BI Desktop here in a few days. I don’t know this for a fact, but I’m just guessing.

I’m very excited about this feature in Power BI and I know many of you are, too. I can’t wait to see all the really cool ways people in the Power BI community will use the new Drillthrough Filters functionality. Leave me a comment down below and let me know what you think!


Categories: Uncategorized
Rate this article:
No rating


Other posts by DustinRyan

Please login or register to post comments.