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.
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.
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.
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.
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!
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!