WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI Drill Down

Power BI Drill Down

What is Drill Down in Power BI?

Drill Down is nothing but the next level of hierarchical insights of the data. For example, when you show a year-wise sales summary you may want to dig deep into “Monthly” summary, “Quarterly Summary” and also a day-wise summary. So this is where the drill-down feature of Power BI plays a crucial role in showing up detailed drill-down insights.

Going from the general view of the data to a detailed view by just a click on the mouse. The reason why drill down is an important power BI feature because, in a yearly revenue chart, you may see overall sales as “2 M,” but there are chances where the majority of the revenue generated in a single quarter or few months itself, so drilling down general view of the summary into deeper will give the correct picture.

Power BI Drill Down

How to Use Drill Down Option in Power BI?

You can download the workbook to use the same file as we used in this example.

You can download this Power BI Drill Down Feature Excel Template here – Power BI Drill Down Feature Excel Template
  • To demonstrate this, we are going to use the below data that you can download as an excel workbook to practice along with us.

Power BI Drill Down Data

  • Now create a clustered column chart to view yearly sales summary for this drag and drop the “Order Date” column to “Axis” and “Sales” column to “Value.”

Drag Columns

  • This has created a yearly column chart.

Power BI Drill Down - Column Chart

  • Under “Axis” when we drag and drop the “Order Date” column, we can see it has created a hierarchy of date in terms of “Year, Quarter, Month, and Day.”

Axis - Order Date

  • Whenever there is a hierarchy, we can make use of “Drill Down & Drill Up” options. When you closely look at the bottom of the chart, we can see some arrow keys.

Power BI Drill Down - Drill Down Options

The first one is “Up Arrow,” the second one is “Down Arrow,” the third one is “Double Down Arrow,” and another one of “Expand” options.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • As of now, “Up Arrow” is not active because in the hierarchy of order date first option is “Year,” and also chart is showing “Year” summary only, so we cannot go any further up.

Up Arrow Not Active

  • The next option below the “Year” is “Quarter,” so now, if you click on “Double Down Arrow,” it will show the chart “Quarterly-wise.”

Power BI Drill Down - Double Down Arrow

  • As you can see above, we have clicked once on the “Double Down Arrow,” and it has taken deeper into the next level, i.e., “Quarterly-wise” chart and also “Up Arrow” is active now since we have moved one level down or one hierarchy down now we can go up.

Up Arrow Active

  • Similarly, when you click on this “Double Down Arrow,” it will move one more level further and shows a monthly summary.

Power BI Drill Down - Click on Double Down Arrow

  • Now it is showing a monthly summary. Similarly, when you click “Double Down Arrow” one more time, it will take you to the last hierarchy level, i.e., “Days.”

Days Data

  • After reaching the last hierarchy level, we no longer drill down.

Power BI Drill Down - Down Arrow not Active

  • So now if we press the drill up option, it will take us above levels from the current level, i.e., as shown below.

Days >>> Months >>> Quarters >>> Years.

  • When we are the first hierarchy level, i.e., “Years,” we can see the “Expand” option is enabled.

 Expand

  • This will expand everything at once. Click on this option to see its impact.

Power BI Drill Down - Expand Everydata

  • By clicking on this option once it has taken us one hierarchy down, i.e., “Year & Quarter,” now click one more time to see “Yearly, Quarterly & Monthly.”

Year - Qtr - Monthly

  • “X-Axis” values don’t look neat, isn’t it? This is more to do with settings of the “X-Axis,” first come back to the “1st Hierarchy” level, i.e., “Year.”

Power BI Drill Down - GO Back

  • Now click on the “Format” option. Click on the “X-Axis” drop-down list.

X Axis

  • From “Type,” choose “Categorical” as the option.

Power BI Drill Down - Type Option

  • The moment you choose “Categorical” as the “Type” option at the bottom of the same “X-Axis” option, it will enable the “Concatenate Labels” option.“Turn Off” this feature.

 Concatenate Labels Option

  • After this, click on the “Expand” option to see then neat alignment of “X-Axis.”

Power BI Drill Down - Expand Neatly

Now we can see “Year” only once for all the four quarters.

Drill Down Feature For Non Date Columns

Not only for columns also for non-date columns too, but we can also apply this drill-down feature.

  • For example, we need to see “Category-wise” and “Sub-category-wise” drill down a summary for this first insert “Category-wise” chart.

 Drag Category

  • Now, look at the chart.

Power BI Drill Down - Category Chart

  • Now drag and drop the “Sub-Category” column to just below the “Category” column under the “Axis” of the chart.

Sub Category

  • Now, look at the chart.

Power BI Drill Down - Drill Down Appears

As soon as we insert another field chart has enabled drill down option, so using drill-down, we can see both “Category-wise” & “Sub-category wise” summary chart.

Note: Power BI Drill Down file can also be downloaded from the link below, and the final output can be viewed.

You can download this Power BI Drill Down Feature Template here – Power BI Drill Down Feature Template

Things to Remember

  • Drill Down requires a hierarchy of the columns, which is to be used with visuals.
  • Date hierarchy is automatically created.
  • Not all the visuals support drill down and drill up features.

Recommended Articles

This has been a guide to Power BI drill down. Here we discuss how to use the Drill Down feature in Power BI to summarize the data in the next hierarchical level along with examples. You may learn more about Power BI from the following articles –

  • Drillthrough in Power BI?
  • Microsoft Power BI Career
  • Parameter in Power BI
  • Drag and Drop Examples in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Download Power BI Drill Down Feature Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download Power BI Drill Down Feature Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More