How to add a drill through button to a visual in Microsoft Power BI
Your email has been sent
Triggering drill through in a Power BI visual isn’t obvious and might be totally missed. Instead, add a drill through button that displays drill through instructions.
Power BI performs a lot of tasks internally, which is a good thing for designers. In many cases, you can build upon those tasks. For instance, Power BI automatically adds drill buttons to visuals when you build drill through functionality into a visual.
However, those buttons aren’t always obvious in a visual, so Power BI lets you add buttons with the same functionality that are more user-friendly. You can also right-click a series and click through a couple of dropdowns to drill, but this route isn’t obvious either.
SEE: Hiring kit: Microsoft Power BI developer (TechRepublic Premium)
In this tutorial, I’ll show you how to add drill through buttons to a visualization in Microsoft Power BI. Thanks to the text property, you can display meaningful instructions, so end users don’t miss out on the detailed data they need. For this tutorial, I’m using Power BI Desktop on a Windows 10 64-bit system.
Here, you can download the Microsoft Power BI demo file for this tutorial and follow along.
Jump to:
Drilling through data is a feature that many users rely on for a more detailed glimpse into visual data. They might expect drilling to work with a simple double-click, but that won’t trigger Power BI drilling.
End consumers use the drilling functionality to analyze and explore data at a greater depth than they can do with surface-level data; you’ll definitely want them to be able to take advantage of this feature, so they can derive more value from their data insights. That means making the feature obvious and easy to use.
SEE: The Complete Microsoft Power BI Super Bundle (TechRepublic Academy)
To trigger a drill through visual the traditional way, the end user must right-click a series in the main visual (the summary visual). Then, they must click through two dropdowns to get to the details. Not only is that too many clicks, but it’s also not user-friendly. That’s why you, the designer, should consider supplying drill through buttons instead.
Figure A shows a monthly sales summary. The Fields pane shows the fields in this summary visual. The Table visual in Figure B is the detailed sales records. Check the Fields pane to see the fields in this visual. Also, check the Drill Through section bucket. As you can see, it’s the Month field from the Date Hierarchy. Power BI adds the Date Hierarchy when you import a Date/Time data type.
Figure B
Notice that the pages have names but not numbers. Page 1 is Summary and page 2 is Sales Details. You’ll need to remember this information for later in our process.
Once you add the drill through field to the detail visual — the one on page 2 — you can use the feature. Simply right-click a month in the summary visual, and Power BI will display the detailed sales records for that month.
The problem is that right-click and follow-through. First, you must know that a right-click leads you to a detailed visual, and second, the process requires three clicks. That latter fact isn’t too big of a deal, but you can make it easier and more user-friendly for end users if you make the functionality more prominent.
You can’t skip this step. If you do, Power BI won’t know how to connect the two visuals. In this case, the Table visual displays the sales record for the month selected in the donut visual, and that happens only because you specified a drill through field (Figure B).
If you’re not familiar with the drill through feature, you can read Understand Microsoft Power BI’s default drilling for more information.
With the drill through feature activated, you can now add buttons to make the functionality more obvious to end users. Return to page 1, select the donut visual and add the button as follows:
Figure C
You might have a hard time finding the blank button, but if you look closely, it’s in the top-left corner, on top of the drill through feature’s default button. Simply drag it down, and you’ll see both buttons (Figure D).
Figure D
We didn’t discuss the default button earlier; it’s a nice way to get back and forth between the main and detailed visuals. You must press and hold down the Ctrl key for it to work properly, which is another thing your end users might not know.
With some simple formatting, the blank button will become a user-friendly button that end consumers will readily recognize and use. With the button selected, Power BI displays the Format pane. Make the following changes to the button:
Figure E
Figure F
Now, let’s use this button to quickly navigate to the detailed visual. To begin, return to page one, Summary. Click June in the donut visual, and then, hold down the Ctrl key and press the See Details Report button shown in Figure G. Doing so will display the detailed visual on page 2, Sales Details, filtered to display only the records for June.
Figure G
The tooltip tells end users to hold down the Ctrl key, so even though that step is still necessary, the end consumer now has clear instructions to do so. Once the drill through button is working, you can remove the default arrow button.
SEE: Quick glossary: Business intelligence and analytics (TechRepublic Premium)
In such a simple example, the full impact isn’t obvious. The button is easier to find, and the text certainly makes its purpose clear. But, in a more complex visual with more moving parts, adding a drill button or several can make for a much better and more navigable user experience.
Read next: Best business intelligence tools (TechRepublic)
Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays
Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays
How to add a drill through button to a visual in Microsoft Power BI
Your email has been sent
TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.
This is a comprehensive list of the best AI art generators. Explore the advanced technology that transforms imagination into stunning artworks.
Find the perfect payroll service for your business without breaking the bank. Discover the top cheap payroll services, features, pricing and pros and cons.
Is NordVPN worth it? How much does it cost and is it safe to use? Read our NordVPN review to learn about pricing, features, security, and more.
Free project management software provides flexibility for managing projects without paying a cent. Check out our list of the top free project management tools.
Australian and New Zealand enterprises in the public cloud are facing pressure to optimize cloud strategies due to a growth in usage and expected future demand, including for artificial intelligence use cases.
Zero-trust security operates on the fundamental premise that trust should never be assumed, regardless of whether a user or device is inside or outside the corporate network. In this TechRepublic Premium guide, we will explore the benefits of incorporating zero-trust security into your organization’s cybersecurity framework to prevent data breaches and strengthen the protection of …
Every organization relies on data that must be protected and backed up in a reliable and secure way by authorized personnel. While the content or criticality of the data may vary, the processes behind a successful backup strategy are universal. This checklist from TechRepublic Premium will help you establish a standard framework for backing up …
Artificial intelligence comes in many varieties, from tools that respond to customers via chat to complicated machine learning algorithms that predict the trajectory of an entire organization. Despite years of activity and the imaginative ideas found in science fiction, AI doesn’t yet comprise sentient machines that reason like humans. Rather, AI encompasses more narrowly focused …
Data governance is no longer a ‘nice-to-have’ measure in organizations as there is a growing concern around the globe that unregulated use of data can result in serious privacy violations, among other issues. That’s why data governance has topped the agenda in many continents as more efforts are being put in place to provide standards …
Get the web’s best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let’s start with the basics.
* – indicates required fields
Lost your password? Request a new password
Please enter your email adress. You will receive an email message with instructions on how to reset your password.
Check your email for a password reset link. If you didn’t receive an email don’t forgot to check your spam folder, otherwise contact support.
This will help us provide you with customized content.
Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.
Leave a Reply