Drilling into drillthrough in Power BI Desktop

In this video, Patrick looks at how you can use the drillthrough feature within Power BI Desktop. He also looks at how you can drill to multiple fields at the same time. The back image can also be changed and Patrick shows you how to do it!
LET'S CONNECT!
Guy in a Cube
-- guyinacube.com
-- / guyinacube
-- / guyinacube
-- Snapchat - guyinacube
-- / guyinacube
**Gear**
Check out my Tools page - guyinacube.com/tools/

[@annagdm]

Thanks, Patrick! You explain complex features very simply and helped me finish my deliverables for Monday morning!

[@billryan3487]

Love the format, Patrick. Really helps those of us on the learning curve. Thanks very much!

[@lankeastor512]

Guy in a Cube is to Power BI what Shane Young is to Power Apps. Love the content and the format; Makes my workflow much more manageable when I can learn from experts like this.

[@aliazad1118]

Thank very much for your perfect tutorial. I have searched a lot, but I found nothing. Finally, your voice was so clear that I could solve the issue easily.

[@JennyJenn831]

I just wanted to tell you this video was the highlight of my otherwise monotonous day, both for its content, and your style! Thanks! Just subscribed!

[@jamesbarnthouse9724]

Love your guy's videos. Informative but also not boring. Keep them coming!

[@ElenarMT]

HOLY COW MAN! You are legit. I tried so many help pages, gave up and came to you. In 30 seconds, I could achieve what other pages could not communicate in many many words. Thank you for being so great

[@orangutanklaus7035]

thumbs up and subscribed! thank you so much for your tutorials, Patrick! with your instructions my job is a piece of cake ;P

[@josephjoestar995]

Love this guys charisma in explaining things, and the t shirt

[@mshparber]

Thanks for the video! two points : first the back button is there whether I got to the page drilling through or just click on the page standalone. Second, the drill through page remembers the filters even if I return to its stand alone without drilling through. Would like to see those fixed. P.s. And also it would be awesome if the slicers would show the filter values

[@anneli2474]

Super helpful! Simple explanation and easy to mark the key note 👍

[@BaronVonReich]

You are a bloody legend, knowledge humour and such a fantastic teacher, what else can you ask for ! from a friend from OZ

[@jaredw.7712]

I really liked this video. I'm new to power BI and this was super easy to follow, and his charisma is through the roof! Much more fun than reading through the docs.

[@theotoby9110]

I guess im randomly asking but does anybody know a trick to log back into an instagram account..? I was stupid forgot my account password. I would appreciate any tricks you can give me!

[@alijahmaxwell686]

@Theo Toby instablaster ;)

[@theotoby9110]

@Alijah Maxwell Thanks so much for your reply. I found the site through google and Im in the hacking process now. I see it takes quite some time so I will get back to you later with my results.

[@theotoby9110]

@Alijah Maxwell it did the trick and I actually got access to my account again. Im so happy! Thank you so much, you saved my account !

[@alijahmaxwell686]

@Theo Toby happy to help :)

[@acmatede]

Pretty nice! Found a report today that blown my mind with that stuff! Now I know what it is!

[@markghanayem5879]

I like pie charts too. Good stuff as always! thank you.

[@catmancooper907]

Great explanation! Love your videos

[@PaulLundgren1970]

Very concise and easy to understand. You've earned a new subscriber. Thanks much.

[@GuyInACube]

Love it! Thanks for watching and subscribing! 👊

[@ttfweb1]

Whoohoo! Easy once a smart guy like you explains it. Thanks!

[@GuyInACube]

Glad it helped! Thanks for watching!

[@abhishekparihar1]

Working on same please let me know which last video you talking related to this current exercise

[@Soulenergy31]

Thank you Guy in a Cube, is this drill-thru option visible in its published version as well?

[@JoseLuisArques]

Hi Patrick. Thanks for the video. It's really useful! I have a question about the information in the Sales Details ribbon. How can I do to show in the top only the country or the color that I choosed in the other ribbon? Thanks for your help.

[@tiptapkey]

"If my end user asks for a pie chart, I give 'em a pie chart."

[@laynepa]

Some videos are full of content and no fun to watch, some videos are fun to watch but sparse on content. You sir have both! I enjoyed watching and learned a lot!

[@nadfran70]

Patrick! You are SO good at this. Swoon.

[@GuyInACube]

Appreciate that! 👊

[@prakashkulkarni1013]

Thank you for the demo of the Drill-through configuration. How will this work with Parameterized Values? Do you have any video to demo it's config and working?

[@ladonnabee1870]

Great tutorial! Thanks!

[@meganpritchard5792]

Very cool - easy to follow even for beginners like me - thank you :)

[@pukey1050]

Really helpful video. Thanks!

[@johnnyvlee]

Experienced developer, new to PBI. So, this is great if you want a prefab drillthrough. What if you want the end user viewing this to choose the parameter for drilling through? For example, provide a grid with a dropdown with a list of field labels and when you click on a row in the grid it drills using the field selected in the dropdown.

[@haydenramsey3987]

Thanks, Patrick! Super help as I'm just starting out. I've created a USA map showing percentages of infants born with hearing loss by state and want to drill through to a second page that shows the states percentages compared to the national average. When I do a drill through to the second page, Power BI defaults to reflect to show only one state. Can I set it up the drill through so that I can chose any state from the map and the drill though tool show every state compared against the national average?

[@pgp2127]

Thumbs up! got what i exactly needed. thanks.

[@GuyInACube]

Awesome! Thanks for watching Peter!

[@baburajendraprasad7406]

Hi Patrick, can we have any feature like when i click on bar chart one of the bar i want to get respective data in a table. As simple hyperlink of bar chart

[@joychang564]

Hi Patrick, Thank you very much for all the videos. Really learnt a lot. Regarding drill through, could I have automatic drill through when selection in slicer? For example, My slicer : manager names My visual : stacked bar chart When I select all managers, my visual show figures for all managers. When I select manager A, my visual can automatic drill through to members under this manager. Thank you.

[@rahulsalvi6623]

Hi Patrick, loved your videos. Is there a way to drillthrough to more than one pages? E.g. Order -> Product & Order -> Customer?

[@DesiRobot]

Thanks! I was looking for exactly this info.

[@tookapaxkmk7963]

thanks man. super simple, will add this to my arsenal.

[@syren77oggie]

This is great! I recently built a report utilizing the Drillthrough feature for a “Details” page, which is outstanding, but now I have other high level stakeholder reports that want to Drillthrough to the same page in my original report, so I keep renaming/saving the origin report and keeping the Drillthrough “Details” page then creating a different report pages around it (sure there’s a better way, but I’m still learning, so no big). So, I thought about using URL links to create a dynamic filter to a completely separate “Details” report that multiple reports can link to. The conditional column and links worked, but the filtering did not. I’ve re-scratched a few times and took a few day breather to contemplate, but still no filtering. At first I was using the URL of the Drillthrough “Details” page from the original report (test version), but only the first row project information would show. Then I created a completely separate test report (just the “Details” page) with no Drillthrough features, now ALL the projects try to show, depending on the visualization. I feel like I’m missing something super simple. Any ideas?

[@RajendraPrasad-pt4yk]

Thanks for your videos it helps a lot Thank you so much

[@kishataylor6963]

Patrick...love the content and the energy you bring. Question though, do u guys have a Playlist for beginner's looking get from zero to hero ?

[@yonahcitron226]

Great content!

[@johnbartlett8832]

Hi Patrick, loving your videos. I have a report where the second page, the target of my drill-through, has a drill-down hierarchy. I want it to always be at the top level of the hierarchy after a drill-through, but can't figure out how to do that. Any help? Thanks.

[@TheOoooooppp]

How did you display the country and color drill through selections at the top of your drill through table?

[@marcusalexander7842]

Thanks for the breakdown.

[@GuyInACube]

Most welcome! Thanks for watching 👊

[@hermanisT1000]

Thanks a lot for such a simple explanation.

[@GuyInACube]

Most welcome! Thanks for watching!

[@mangeshmehendale4139]

This is brilliant! I was looking to understand what drillthrough is all about - I dont need to look further. Cheers!

[@GuyInACube]

Thanks Mangesh! Glad the video we helpful for you. 👊

[@kendallshortt5171]

Thanks for the great explanation in the video. It works great but I have one issue that maybe you can help resolve? Once I drillthrough to the next page, I want to see the specific records but PowerBi won't keep the filters from the original page I started from. Any tips?

[@ankursrivastava8635]

Hi Patrick, It is very nice video to learn Drillthrough option. I am facing an issue with drillthrough option on smartphone or any other touchscreen device. Because they haven't functionality of Right click, so users are not able to use it on touch screen devices. Can you suggest a way out to use drillthrough option with the touchscreen?

[@dbszepesi]

Still waiting on slicer settings being carried along *if desired* as 'state' when you drill. Customer asks about that often. Sounds like slicer state is being worked on though based on some of the notes I saw for PASS.

[@TheGksharrow]

Also the ability to drill through on devices with no right click (e.g. Ipad).

[@TheBIWizzKid]

kzbin.info/www/bejne/eaa3ZoqqocmSn7d9s this what you mean?

[@sau002]

Nice video. How did you display the name of the drill through Country on the Detail page?

[@pgayatri559]

How can we implement same drill through feature for 2 different linked reports , Hope you have a solution for this. I wanted to pass a value from a main report to the multiple detailed analysis report using this feature, which I have created using hyperlinking concept

[@SonuPandey-me4fs]

It's great. Can we make a arrow button to go directly drillthrough page or by clicking on any mark on chart. Or we have only the default way to drillthrough.

[@nataschalaros418]

Hi Patrick, I have a question about the drill through. I have a report with 5 pages each based on different data, but all having YEAR and MONTH as a column. If I make a drill through from PAGE 1 to DETAILS PAGE 1, I get to choose details from DETAIL PAGES 1, 2, 3, 4, 5. But I only want the DETAIL PAGE 1 to show up in the drill through selection. Hope you can give me some good advice ;), Grtz, Natascha

[@framusk5585]

Very clear! Thanks

[@nijamkhan1]

Hey Patrick, its nice explanation. Can i have sample data source to do the practice.

[@taylaburgess174]

Thank you so much!

[@naserdaneshi5026]

Thanks Patrick! It was a good tutorials, but my question is how we can drill through by clicking a Button; not right click on the chart and select sub menu; Lots of users told me that "Is that possible just clicking a button or not". Does PBI have such this feature ?

[@akhilakrishnamurthy5562]

Hi... I just started looking at your trainings and they are excellent.. quite in detail.. but in this video I observed a "drill through" filter option which I can't find in my pbi desktop. Any idea why?

[@mustafabiviji00711]

Patrick, Thanks for showing the drill-through feature with multiple fields. I have slightly unrelated question: Is there any work-around to select Australia on say the the map and silver on the pie chart and see the third detailed visualization (on the same page) or another page being filtered by both values (Australia & Silver)? That is, is there any work-around for multi-select in multiple visualizations?

[@kamleshraina9454]

Hi, This is really great and fun to understand from your videos. I am new to powerbi so nees your help in my requirement. I have a table with month, yeat and sales. I need to display 3 months at a time with average of last 3 months before and including that month. Eg.. I display Jan-17, Feb-17 & Mar-17 as header and then below that vlaues should be average of Nov-16, dec-16& jan-17 for Jan-17. Average of dec-16, jan-16 & feb-17 for Feb-17. Average of Jan-16, Feb-17 & March-17 for March-17. This has to bw dynamic with a drop down where user can select a month and a year and table should show 3 months before and including selected one. Sorry for the typos if any.

[@nomaanahmedsyed5649]

Does the drill through function also work for a matrix with a hierarchy (different levels of rows)?

[@umarqayyum1098]

thank you very much for the tutorial

[@RajendraPrasad-pt4yk]

can we do drill through on measures and % values. i got this requirement from one of the user .. please help me if it is possible

[@pratk30]

can we drill with same method on same page if details visuals are on same page?

[@rahulrathnam4118]

Hi Patrick! Great job. But I have a question, the columns you add in the drill through somehow get detected as drill through in visuals on the other views as well although I don't want those columns to be drilled down from that visual. So is there any way to avoid that? Please let us know cuz this is a doubt for many people out there?

I have similar problem. User will select some rows on table or matrix and they will press next button for page 2. I will compare selected rows on page 2. i need to show them like compares of the 2 branches....

[@scottrskit]

Nice thanks! But, I just want to click on a row in my table and have just that category populated in my chart? to see it's volume month over month. I can only figure out how to to do that in the reverse direction.

[@mohammedahel6921]

Very Helpful Thank you very much

[@yachanagupta4401]

can we apply drill through filter on multi row card.

[@ajithr1255]

Thank you!

[@PranayPawar1991]

Thanks buddy.. Its awesome

[@GuyInACube]

Great! Thanks for watching! 👊

[@mannuut]

Superb....Thanks a ton

[@prashanthdar2675]

I have two pages in a Power BI report with different page level filters on both the pages. Page 2 is details of page 1, when I drillthrough from page 1 to page 2, can the page level filters in the details page be removed to adjust to the drillgrough field from the page 1?

[@akshaykhiste9104]

Can we restrict filter in one of visual in landing drill through page ?

[@hseyedagha]

Dear Patrick, It was amazing and so useful method. After watching this video, I used drill through in my report and the result was so breath taking to my boss. Many thanks. I just have a question about those boxes show the all colors and all countries. How can I make them? Would you please help me ? Are they cards, or sth like that ?

[@manjugoswami6733]

Can you help in drilling through to different columns of a Clustered Column Chart?

[@anmolganju1864]

@guy in a cube Jus wanted to ask this Hope you have answer for this:- I have a PowerBI report that contains bar graphs that date and other information and a Bing Map that is linked with the bar graph. Now the bing map contains latitude and longitude and some other information like date, and it has the same date column that is used inside the bar graphs. Now I am using a drill through feature here which drill through the map when I select a bar graph and use any of the data visuals inside the map to drill through, now when I drill through this other page contains different information of the bar graph like date and other things. The problem is when I use drill through on a certain visual inside a map I dont get the exact date that is shown inside the tool tip of the map and the bargraph, thats why because I have the same longitude and latitude that contains different dates and the drill through feature is just showing me the latest date of that longitude and latitude, how can I make this useful so that I get the exact date which I can see earlier on the tooltip of the map and the bar graph any suggestions will be helpful.

[@free07styler]

thanks man!

[@BrianEHo]

Nice video. Is it possible to carry over the date in the slicer to the detail page when you drillthrough? I have a couple slicers defined in the summary page and would like to pass them to the drillthrough page. Thanks.

[@GuyInACube]

You can do that from a Sync Slicer perspective. docs.microsoft.com/power-bi/visuals/desktop-slicers#synchronize-slicers-across-report-pages

[@faisalmohammad2516]

Hi , can you please advise if we have any feature in Power bi to make measure clickable rather than using drill through.

[@manuelsahinoglu392]

I love you Patrick!

[@safescubadivingwithanis]

Awesome....thanks for that

[@AliTwaij]

excellent

[@sarmand70]

Hello Patrick, I would like to drill through from a gauge visual. I have a bunch of gauge visuals on one page, and I would like to drill through to a second page that has details behind the gauge. So far, I have not been successful. Is it possible to drill through from a Gauge visual?

[@Rexny]

yo much thanks for the video!

[@alaflen7634]

Love the video! I noticed when you move into details the filters are not passing? When will slicers be able to affect the entire report?

[@GuyInACube]

:) Stay tuned on that. Don't have a timeline for you.

[@whitousatan4438]

i have a question and its unrelated but i dunno where else to ask. i have a clustered column chart, IDs as an axis and 4 different values that are lab analysis results. i also have a date column which indicates when analysis was made. we run periodical lab analysis on those IDs that are basically samples so the data is going to be periodically updated. i need my report to show LATEST values for the IDs whenever i refresh report. there are options to show maximum or minimum or sum of the values per ID, but i need the report to show me the up to date info, that being latest lab results for each ID that will be updated on my source excel file. is there any way to do that?

[@srirambharat9572]

thanks a lot!

[@vikramshah3445]

Hey Patrick, I would like to drill through to a page from values in a slicer. Is this possible, I am not able to achieve this.

[@My-life-captured]

Hi can we use drill through on one page with different data

[@kruturajnikam2604]

Hi, I configured the drill down as shown and published the reports online. I am even able to drill through but how should i reset this, i am not able to find any options to bring my reports to normal. Can you please help me here..

[@tacijjola]

Thanx Patrick! :)

[@qiancasper]

Hey Patrick just wonder what's the key difference between tooltip vs drill through could you spend a bit of time to help me figure it out appreciate your help here

[@michaeleagan6449]

Can you drill through a Line Chart?

[@aks9780]

Can we restrict a drill through to only selected widget ? lets say i have a field sales on two visuals and i want Drill through for only one . Can i do that?

[@raghujagwani3164]

Do you mind sharing the sample files?

[@brendancolley7353]

Thanks Pat, super helpful video and now my dashboards look a little better #incrementalgains =)

[@nandhuse]

Can Tackometer have drill down or drill through?

[@giri41]

great video

[@GuyInACube]

Appreciate that Lakshmi! Thanks for watching. 👊

[@ummelaraib5537]

Hi, Thank you so much. Just a simple irrelevant question, how to get Guy in a Cube T-shirt :)

[@ronjcash]

When I click the back button it does go back to the source. But when I click the tab for details, the results are still filtered. Is there a way for the filter to be removed, when clicking the back button? And what are the options available for clearing the filter on the detail page after having clicked on the "drill through" from the source page?

[@manjun1892]

Is it possible to just click and navigate to next page instead of Drill through option.If I have a table of products and then I need to navigate to another for a particular product that is clicked through from the 1st page

[@ivanmisic1826]

Hey Guys, does anyone know how to change the color of Visualisations and Fields panes like he is having on the right? Thanks!