EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Data Science Data Science Tutorials Power BI learn Power BI Drillthrough

Power BI Drillthrough

Priya Pedamkar
Article byPriya Pedamkar

Updated March 27, 2023

Power BI Drillthrough

Drillthrough in Power BI

Drill through in Power BI is used for filtering the data with certain values and parameters so that the user can focus on the things he/she wants to show. Most of the time when we create any dashboard or charts in Power BI or in any other tool we concentrate on showing the overall progress report of the project or business. But with the help of Drillthrough operations in Power BI we can filter the data as per requirement and break that into small projections so that getting the actual figures of mail data set becomes easy.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

How to Use Drillthrough Filter in Power BI?

For using Drillthrough in Power BI, we need to follow the steps for creating a dashboard view in Power BI first. And for that, we need data to work on. Below we have the screenshot of sales data of some electronic products such as Laptops, Desktops, Tablets, and Mobiles. And this sales data consists of different categories such as Salesperson, regional customer name, unit price, quantities, and dates. And the maximum range of the data is up to 1000 rows.

Power BI Drillthrough Example 1

We can sort the data if required. Here we will be sorting the data once we start working on it in Power BI views as then require. You can also download the excel workbook from the below link which is used for this example.

You can download this Power BI Drillthrough Excel Template here – Power BI Drillthrough Excel Template

Let’s go through a step-by-step procedure and use Drillthrough in Power BI. The steps in detail are as follows:

  • Load the dataset into Power BI. For that click on Get Data Menu under Home Tab. From the drop-down menu of Get Data, select appropriate data source type. In this case, it is Excel, so clicked on Excel as shown in the below screenshot.

 Example 1-1 (Menu Ribbon)

  • From the drop-down menu of Get Data option, select the type of file source which we want to upload. Here, our data is in Excel format. Once we select the file, in the navigator window, it will ask us to select the sheet which we want to upload. It is because, there might be more than 1 sheet with the data but the sheet we want to choose can be anything. After that, click on the Load button highlighted in yellow to load the data into Power BI.

Example 2 (Navigator)

A few moments later, the Sheet will get uploaded in Power BI.

  • Let’s create our first view, by which we will show different sale of all products types. For this select Columns Stacked chart from visualization.

Example 3 (Staked Chart)

  • Drag the Product type and Quantity fields into Axis and Value section of selected visualization.

Power BI Drillthrough Example4

  • Do the basic formatting such as data color, data labels as per need to get a final view.

Power BI Drillthrough Example 5

  • Now we will create a Pie Chart or Donut chart by which we will show Sales person wise graph. For this select the Donut chart from the visualization.

Example6 (Donut chart)

  • Now drag the respective fields to see the values in selected Donut charts. Here we have selected Sales person names and quality sold by them.

Power BI Drillthrough Example7

Then our Donut chart will look like as shown below. In that, we can clearly see, out of the total sale, which Sales person holds what percent of the shares.

Power BI Drillthrough Example 8

  • Now, we will insert another Page in Power BI report and name it as Customer-Wise Projection. As we can see in the screenshot of the data which we have uploaded in Power BI, we have a column as Regional Customer Number, which we will use here.

Example 9 (Customer-wise Projection)

  • Now we will drag Salesperson, Regional Customer Number and Unit Price into the values.

Power BI Drillthrough Example 10

  • This will give our table chart as shown below where we can see which salesperson has what customer numbers under that how much sale he/she has pulled up.

Example11 ( Table Chart)

  • After formatting, the table chart will look like this as shown below.

Power BI Drillthrough Example 12

  • We will then create another page for Customer and volume-wise sale as shown below.

Power BI Drillthrough Example 13

  • Here, select the Funnel chart and then drag the Regional customer number and Quantity in the relevant fields section.

Power BI Drillthrough Example14

  • After formatting, we will have our funnel chart as shown below. This will show which customer has order how much quantities of products.

Power BI Drillthrough Example15

Now here comes a point, where we will add drillthrough in each of the page which we have created. We will create a breakup of complete sales data with sales person’s names.

  • For this, in the current sheet which is Customer v/s Volume, click right on Salesperson in the field section and select Add to drillthrough from menu list.

Power BI Drillthrough Example 16

  • We will see, Salespersons name will get added into drillthrough.

Power BI Drillthrough Example17

  • Once we do that, we will see a back arrow will appear on the graph.

Example18(Funnel Chart)

  • Now we will add Salesperson from the Customer-wise Projection page into the Drillthrough section.

Power BI Drillthrough Example19

  • Now we are all set with all Drillthrough which we could require. After that, we will go the first page where we have created Donut Chart for Salespersons and Column chart for the product type.

Power BI Drillthrough Example 20

  • As we can see in the above screenshot, in Donut chart we have all the Salespersons names and their respective sales numbers. This chart has Anand, Rosy, Shraddha, Ashwani, and Aniket as the salespersons. Now suppose we want to drill through any of the salespersons, let say Rosy. Then click right on that name and select the option Drillthrough from there. Let’s select Customer-wise Projection first.

Power BI Drillthrough Example21

  • We will see the drillthrough will take us the second page and filter the data with the name Rosy. Go back, Click+Ctrl on back arrow.

Power BI Drillthrough Example22

  • Now if we want to drillthrough Anand’s data then click right on it and select Customer vs Volume.

Power BI Drillthrough Example23

  • This will directly take us to that page and data will also get filtered.

Power BI Drillthrough Example24

Similarly, we can apply Drillthrough and get a deep insight of any project.

Note: I have done so much of formatting to this table and charts, you can download the Power BI Drillthrough file from below link and apply each formatting technique as applied.

Power BI- 

You can download this Power BI Drillthrough here – Power BI Drillthrough

Pros of Power BI Drillthrough

  • This helps us in getting deeper into project data.
  • We can analyze any part of the data set.
  • We can create any number of drillthrough views.

Things to Remember

  • First, find the area which you want to dig to get insight.
  • With the help of the Back button, we can go back to the first page.
  • Drillthrough only provides the breakup of report or we can filter the focus group and perform our further analysis.
  • Drillthrough is like filtering the data. But this filters all the created charts with relevant fields we choose.

Recommended Articles

This is a guide to Power BI Drillthrough. Here we discuss how to use Drillthrough Filter in Power BI with an example and downloadable template. You may also look at the following articles to learn more –

  1. What is Bullet Chart in Power BI?
  2. Power BI Themes | How to Sets?
  3. Power BI Parameters | Examples
  4. How to Implement Power BI SUMX?
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Power BI Drillthrough

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA

Download Power BI Drillthrough

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW