Power BI Drillthrough Updates

Did you know there were Power BI drillthrough updates? In this video, Patrick looks at the drillthrough updates in Power BI Desktop. This includes Keep All Filters which will pass the filters on your parent page to the drillthrough page.
LET'S CONNECT!
Guy in a Cube
-- guyinacube.com
-- / guyinacube
-- / guyinacube
-- Snapchat - guyinacube
-- / guyinacube
**Gear**
Check out my Tools page - guyinacube.com... #powerbi #guyinacube

[@eleftheriosioannidis2144]

Life saving! This can actually replace the issue that "View as a data point" option has - not being able to select the field. Amazing! Going to "Drill Through Next Level" video next. Well done guys! Such a good work

[@premjitchowdhury262]

Classic Gary Coleman quote at 3:17.... Nice that people still remember it.

[@learnspreadsheets]

My biggest problem with drill is that once in drill through page you can’t clear filters with slicers. It must have a clear all filters bookmark. Once this is there it’s great! I use it tonnes for navigation

[@salosteysv]

Hello guys! Great solution! Thank you! The question is not the topic. About Power Query. Do you know how to extract hierarchical data separated by indent levels, from one Excel column? I.e: USA Washington New York ... Canada Vancouver Toronto ... Etc. It is necessary to receive: USA | Washington USA | New York ...

[@lenac3587]

How can we not like your video? You crack me up Guy in a Cube! Love it!

[@diegonoliveira]

Hi Patrick, thanks to you and Adam for all the content and knowledge provide by you. I'd like to know why Power BI Dashboards are estatic, they dont are interactive or filtered based on the reports. On pratic they dont help centralize the most important visuals and analize them in one place. Thanks from Brazil.

[@PhilippeGlaus]

Hi Patrick. Thanks for sharing this video. Makes life easier. :-) One question anyway. Is it possible to keep all the filters and slicers when you hit the back button on the drill-through page? So when I get back to the main page I can go on where I left off before doing the drill-through. This'd be awesome.

[@ShabnamKhan-vk7fj]

This is awesome Patrick. Thanks for showing us all the cool tricks!

[@wynhopkins4023]

Thanks Patrick. Clarified that nicely.

[@tristenc14]

I'm having trouble finding the original video on drillthrough on your page - could anyone provide the link?

[@GuyInACube]

It's added as a card on the video in the info block. Here is the direct link - kzbin.info/www/bejne/aKmcnX9-ecenes0

[@annarozyc5184]

Hi, Is there pospolity to do drillthrough on one page using bookmark and visible and invisible table?

[@sayedmohdasim9234]

Hi Patrick, is there any way to drill down multiple visuals, as we drill one of the visual. Example: I have three different bar charts with x axis value (which is common in three charts) as company name hierarchy (company name and then product name), one of the chart has revenues as values another has gross margin percentage and last bar chart has cost. Now if I drill down on Revenues bar chart to product level, other two bar charts should also go to product level.

[@dbszepesi]

I missed the importance of this as well. Thanks as always for the video!

[@tsoidanny3543]

Hi @Patrick, is it possible to pass "specific" drillthrough filters but not all? (e.g."Product Name", "Region", "Country" but exclude "Year" in your case)

[@luisedugarridosoares]

Hey Guys! I have a use case in which I am using 2 columns as filter for drilltrough. One of the columns has different values (relationship like 1 to many). Is this scenario how to send to the drillthrough report these multiple values at once? Thanks!

[@andr3wpex]

You are cool. No matter which video I watch from this channel, I always enjoy the spirit. :)

[@sukritigarodia705]

Hey Patrick, I need some help on how to drill through if I have made a custom visual. I have 4 custom visuals of forecasting (arima, tbats, maq software neural network and an exponential forecast) graphs and rather than hovering on them for a future week I want that detail to be displayed for all the 4 forecasts on me clicking the filters. Thus if you could help!

[@MrityunjoyBhattacharjee1]

Hi, I have a summarised report to depict the no of open loads for a warehouse and a detailed report for the same in 2 different pages and I want to perform a drill thorugh based on warehouse and week of the year.However it is not working. It is also to be noted that source of the PBI report is 2 Hana Calculation views , one in import mode and other in direct mode.Can you please assist ..I can send the pbix for your reference as well.

[@ajitesh_thakur]

Lova this

[@benmarch10]

I haven't found a way to drillthrough using a left click (without right clicking first). Is there a way to accomplish that or is there a workaround?

[@varadinamdar862]

Hi Patrick, I want to drill though from PowerBI to SSRS report. Scenario: PowerBI - State wise Sales Amount SSRS - City wise Sales Amount If I click on any state in powerBI report, it should drill though to SSRS to the respective cities with Sales Amount. Could you please divert me to correct direction if above scenario is possible?

[@YouWiking]

Really love your videos. And I have a question/challenge ;-) I have a stacked barchart, and I want to use drillthrough, but I want to drill to different tables depending on which part of the bar I click on e.g. purchaed on contract, and purchased without contract. Hope you can help me out.

[@bonsai_mad8139]

Excellent vid as always Patrick!

[@passais]

Your videos are So slick! very professional. You could start a new channel on how to do that :-D

[@blah222blah222]

"sure you can!" Thank you so much Guy in a Cube... =)

[@gokulkathirvel2359]

Is Drill through filter multiple selections of rows is possible??

[@mikekostuch4891]

How to use drill through on an ipad through a browser (not mobile app)? No Right click option and no other option to drill through...(not drill down).

[@don6101]

Can you make a video of drilling through a card? Is it possible?

[@csrajaraman]

Is there a way to hide the drill through page and only enable them when a drill through is requested from the main page?

[@GuyInACube]

You should be able to hide the detail page and leave the parent page unhidden. Have you tried it?

[@renatofreitas3877]

Great. Tks a lot!

[@WanderVagabond]

I want the shirt man ! I love the videos!

[@giri41]

Top man .. Patrick

[@GuyInACube]

Thanks for watching! 👊

[@gazoller]

[@margiekolatac2503]

I am looking for instructions on how to drill to another detailed chart without transitioning to another page

[@ramondrudis1991]

You're the boss! Hi from Barcelona

[@GuyInACube]

Thank you Ramon! Appreciate the comment! 👊

[@asjones987]

FYI for others ... I think this is the link to the original drillthrough video Patrick referenced. kzbin.info/www/bejne/aKmcnX9-ecenes0

[@thalitasylviamarques8626]

Is Drillthrough functionality available for Power BI On Premises??

[@mshparber]

We need a drill-through to a bookmark option

[@amolgupta109]

Drill through is not available in web dashboard ?

[@GuyInACube]

It is not a dashboard feature. It is a report feature.

[@LevanAlibegashvili]

Hi Patrick, useful video as always. Another feature I could find a workaround - is it possible to create a table of contents that could take user to the specific page? Thanks

[@olakitanaladesuyi6236]

You can use bookmark for this

[@joaquimcosta952]

Amazing man....

[@biexbr]

[@GuyInACube]

Power BI loves you also!

[@batmansbodyguard]

:D

[@dhulipalamurali]

your hyperactive nature is distracting concentration on subject you are explaining. Please be be normal. It is request..

[@jerrycote1661]

I kinda like it. I call it enthusiasm.

[@anushakadarla6]

Hi, I watched your video for the first time and I like it...I have a question, I have 2 different Sqls with different columns, just one to 2 columns in common like full name and date...I need to build a report with the high level data using SQL1 and then when some value like full name is clicked it should drill down to another page or another separate report which has different dataset and using SQL2 which has details of the selected value from page 1. Would that be possible?