DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL

Подписаться 220 тыс.

Просмотров 116 тыс.

50% 1

Learn how to use drilldown and drillthrough in Power BI. Take you visualizations to the next level!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on RU-vid: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX

Наука

Опубликовано:

17 июн 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 126

@williamharper9948 Год назад

Extremely well done. All aspect of drill down, up, ... and drill through were well explained. Thanks so much for sharing this video.

@ivannakoniukh3855 3 года назад

This is the best what I have seen so far

@vamsiharati3206 11 месяцев назад

Brill !! Lot of concepts in one video .. Thanks 👍

@TrassBI 3 года назад

Great content and very useful👍Thanks!

@shabnamkhan7235 2 года назад

This is great, thanks for the great content!

@nonoobott8602 3 года назад

Great video. Very very explicit. Thanks so much for this. Looking forward to more amazing content

@HowtoPowerBI 3 года назад

Thank you! More to come!😀

@kookooiam6034 Год назад

thank you for explaining this so well, other channels skim over the details and only show a portion of what each function can do... you explain each function of the subject in great detail giving many different examples... I am so thankful for your videos

@rschloch 10 месяцев назад

Easily the best power bi tutorials in RU-vid. They’re crazy good.

@shraddhapatil7963 Год назад

This is really good. I have been looking for this information. You explained it in very detail and in easy way. Thanks a lot

@Sipbykarey Месяц назад

Wow!! So simple and insightful

@rajprabu6040 Год назад

U r awesome man... Thank you

@kishore_p93 3 года назад

Great video. You have covered up all the important features related to Drill down and Drill through. Thanks! 🔥

@HowtoPowerBI 3 года назад

happy to hear 😀 thanks!

@salehmuhammad6811 2 года назад

Masha Allah how good is that to interpret and explain. Good bro may Allah give success to your effort & Allah bless for next amazing contents.

@Xevailo Год назад

I should have watched this video WAY earlier! Excellent explanation :)

@McGregor2688 3 года назад

Excellent content... Thank you so much, this is quite useful!!

@HowtoPowerBI 3 года назад

so nice to hear, thank you!😀

@marufibragimov2579 3 года назад

I've finally I learned what that Drillthrough button is for. Thanks a lot. Great explanation

@HowtoPowerBI 3 года назад

thank you!

@MelanieM63 3 года назад

Best explanation ever! Thank you for this. 🙂

@HowtoPowerBI 3 года назад

thank you Melanie! 😀

@ramyessam8537 2 года назад

Thanks for your great explanation .. I have one question: After drilling through a certian dimension and go to the drill through page, can I change the filter context while being in the drill through page? I have a trend line chart at the drill through page, if I come from the main page while selecting November month for ex, I want afterward to see other months trends as well

@matiasmey5477 Год назад

I have to say I am loving your videos!

@HowtoPowerBI Год назад

Thanks Matias!

@anamqureshi802 3 года назад

Thank you very much for the video It was easy to grasp

@HowtoPowerBI 2 года назад

Glad to hear that Anam!

@framusk5585 2 года назад

Very clear! Thanks

@HowtoPowerBI 2 года назад

thx for watching Fra 🙂

@Mardop1 2 года назад

You are the MASTER-DRILLER dude! Thank you very much! :D

@HowtoPowerBI 2 года назад

Hahahah thanks?!!! ;)

@bhimpujar8639 2 года назад

Really good vid. Thank you. Subscribed.

@HowtoPowerBI 2 года назад

awesome, Thanks for the sub Bhim! 😀

@louism.4980 2 месяца назад

Thank you for the demo! :)

@HowtoPowerBI 2 месяца назад

Thx for watching

@guusvanzuylen6501 Год назад

Excellent and enthousiastic explanation! I do a drill through from a table to a detail table, after that I return to my original table. I forgot from which line I did the drill through. I there a way to highlite this line?

@EricaDyson 4 года назад

Yes. Great. Thanks a lot

@HowtoPowerBI 4 года назад

happy to hear it was helpful :) Let us know if you have any questions or requests for upcoming videos

@samanthapikus3178 2 года назад

Excellent Explanation about this feature.

@HowtoPowerBI 2 года назад

Samantha, I am glad it was helpful! :)

@CanonCrested 4 года назад

This is really good. Got referenced here by Guy in the Cube. Love how we can see the visualization you are working on. Subscribed. Looking forward to the next video

@HowtoPowerBI 4 года назад

thanks for the sub and welcome to our channel!

@vishnupp5944 6 дней назад

Thanks

@hildeverschooten5115 Год назад

Thank you! One problem I come across when drilling down is that it doesn't keep my gradient colours as I set for the top level (red for highest value and green for lowest value). When I drill down I want to keep this gradient colours. How do I manage that?

@vishnurao2901 4 года назад

Great information..Thank you..please upload more videos..

@HowtoPowerBI 4 года назад

thank you! definitely will :)

@kongklas 6 месяцев назад

I like going back to the basics now and then, completely re-learning basic operations as well as being reminded how crap the sound used to be :P

@bobthedruid9378 Год назад

when I drill down, am i able to regroup the data by month? e.g. Jan of 05/06 showing side by side?

@katiamutombene2210 3 года назад

My new Fav channel

@HowtoPowerBI 3 года назад

thank you so much Kátia, happy to hear!!! 😀😊

@totvabe1 4 года назад

Great explanation!

@HowtoPowerBI 4 года назад

thanks! :D

@cyrilzyriacjoseph1961 2 года назад

Thank you 😊😊

@HowtoPowerBI 2 года назад

You are welcome 🤗:)

@user-dh6wx3fe6y 3 месяца назад

Thanks for the video! I’m only wondering how to keep the state of the visualization after clicking Back button from the drill through page?

@eyitayoeyitayo-lawal2331 3 года назад

Thanks. The creation of product hierarchy is a bomb for me. I love it. More grease

@HowtoPowerBI 3 года назад

hierarchies give that finishing touch :) , I would usually set them up and hide the original fields. Many uses cases (for example also for locations -> country, state, city)

@eyitayoeyitayo-lawal2331 3 года назад

@@HowtoPowerBI I was excited to put it to use at work this morning and I was blown out to see that it's just a drag and drop away. A drill down combo Pro by ZoomCharts put icing on the cake. Thank you for replying my mail. I feel honoured. Cheers

@vinayak254 Год назад

great

@rajivchoudhary3148 10 месяцев назад

thank q

@arinbose5778 2 года назад

Thank you so much. Love from India. Can you teach on how to find the top 3 items each year or things like that and drill down on those 3 items?

@balaswamy3779 2 года назад

Hi, can you clarify me the below issues which i faced in Real time. 1. I have created Clustered column chart or it could be any other chart which is having drill down Options. then i click the option " Click to Turn on Drill Down " Option and seen respected data. after sometime the report published in to cloud. here i don't want to select again which i selected earlier like " Click to Turn on Drill Down " Option. Is there any solution for not resetting that option once i published into cloud ? 2. Is it Possible create Drill Through Option in Same Page ?

@AbdullahJan-nv1qd Год назад

Thanks man. Can we drill through a table entry?

@PowerBiTutorials 4 года назад

👏🏻👏🏻

@abrammakgalemele3491 3 года назад

Powerful stuff. 1st video was June 2020 yet so impressive. We will be following this channel closely. Where have you been?

@HowtoPowerBI 3 года назад

doing my best :D , happy to hear you like it! more powerful stuff coming ;)

@Hariharan-eb4os 9 месяцев назад

is it possible in Power BI, when you view your main report and click on a row or data point in the specified visual, Power BI will navigate to the drill-through page

@monicajain2315 2 года назад

Thankyou for the insightful video. Can you please help on how to sync hierarchy in two visualization. I have one revenue graph and another cost graph with same hierarchy (H1

@davidpuddicombe7946 9 месяцев назад

Is it possible to use drilldown for the legend in a line chart? Great video!

@mihaelamironescu9736 2 года назад

excellent

@HowtoPowerBI 2 года назад

Thanks Mihaela

@Smeetr 2 года назад

Good one

@HowtoPowerBI 2 года назад

thx Smeet!

@Mamaditalia 4 месяца назад

Very well explained.

@HowtoPowerBI 4 месяца назад

thank you!!! 😁

@bananageorge2133 2 года назад

Thanks -

@HowtoPowerBI 2 года назад

you are welcome George!

@jhewitthunt 3 года назад

liked that. Very well explained. Be nice if there could be a little button on each tile, so that could be clicked to Drill through rather than having to right click. That way, you could click most places on the tile so it changed the data elsewhere on that page, or click the little button so it went to the extra details page :)

@HowtoPowerBI 3 года назад

That would be cool! although I think if you turn on the drillthrough button from the ribbon goes into that direction. Then you can just left click

@whdea3426 2 года назад

@@HowtoPowerBI yes , but that is a per session thing, it vanishes out even the report . Also at the service it can be enabled from explore option , but it then cannot be saved and is a per session thing. Thanks again , You always make awesome vidos .

@whdea3426 2 года назад

@jamie, were you able to find a solution for this ..

@anupajayakody458 Год назад

Should we enable drill through in the details page visual or in the main page visuals for this to work??

@HowtoPowerBI Год назад

Details

@praveensebastian2107 3 года назад

Good explanation

@HowtoPowerBI 3 года назад

Thx Praveen!!! 😀

@iqrarkhan8129 6 месяцев назад

Please create a video on how to do Hyperlink drill through, mean that we will no need to right click and drill through

@barttitulaerexcelbart9400 4 года назад

Very very good explained. First time I have been here, by coincident. One question: why was your last (not full) year green as opposed to the other years (blue)? You started from scratch and I did not see you format anything ?

@HowtoPowerBI 4 года назад

thanks Bart! I applied conditional formatting, which was not shown in the video to not distract from the main topic. The explanation on how it was done you can find here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-x64KFTbk4Yc.html

@nostromo3986 2 года назад

Drilldown is linked from one graph to another on the same page, but not "go to the next level in the hierarchy" and expand all down one level in the hierarchy. Can that be done?

@janetan864 3 года назад

Hi there! Is there a way to show your drill down data automatically? Like for example, if you click onto year 2020, it should show you the next level hierarchy by default.

@HowtoPowerBI 3 года назад

Hi Jane, that's what happens when you turn drilldown on,.. no? 🙄

@janetan864 3 года назад

@@HowtoPowerBI Hi, currently I understand that users will have to right-click to drill through or click on another the drill down button to view the data. Was just wondering if there is a way to show data automatically after clicking on a data point. Based on my research, it's not possible but I have managed to build a drill through button to help users navigate the report better :)

@carax006 3 года назад

Thank you for all your videos! Very useful! There is an issue about the download of this file,can you sort it out? Thank you

@HowtoPowerBI 3 года назад

thx for pointing it out! should be fixed now! 🙂

@QasimAli-gy3nb 2 года назад

Can we make combination of dimension in drill down like I wanna see my sale over time but wanna see who(customer) a caused that dip in my sale, i.e date and customer. On top of that I also wanna see what product do they buy. In nutshell I want drill down these three dimensions. Is it possible?

@HowtoPowerBI 2 года назад

yes, just place the dimensions on the visual (for example all on rows in a matrix) and you can drill / expand down.

@MrTejasreddy 3 года назад

Awesome video Can u do video on powerbi service

@HowtoPowerBI 3 года назад

Yes, it is on my list 🙂

@OriginalBernieBro 2 года назад

Where is the data csv being used?

@supersayan9888 2 года назад

How do you drill trough from a slicer :), the bar chart cannot go to the next level in a hirarchy. Correct?

@Wzxxx 11 месяцев назад

Well ok, I tried it by I can’t figure out one simple thing. I would like to select 2 categories from a one piechart (ie. phone and screena) on one page and then use drill to go on a details page. I can’t. If I select these 2 categories and any other in anothet chart - it works. It keeps 2 caegories from one chart and one from other chart so I can use drill through. But…i can’t select 2 categories on one chart and drill. Please don’t tell me that MS did not take this into account. It is absolutely out of any sense

@bravucod 2 года назад

Can you make a video of how to create your reset all filters (the icon you have on this report) Thanks in advance!

@HowtoPowerBI 2 года назад

already have it 😁 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_HTF7Ph7Eqc.html .. min 3:02 ...

@bravucod 2 года назад

@@HowtoPowerBI you are the man !

@davidredman8926 5 дней назад

Excellent video. I was wondering if there is a way to drill through cross reports using a button rather than having to right click?

@HowtoPowerBI 5 дней назад

Here you go ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-I7oyyb0Y8Oo.html

@BarryRussell2 4 года назад

Right Click on any bar and you can Drill down

@normandtousignant1754 2 года назад

Good job, I have a request, could increase subject screen and reduce yours? Thanks ;)

@HowtoPowerBI 2 года назад

Thanks Normand 😊 . Considered it, but will be sticking with this format for now

@joefromdc 2 года назад

How do you clear the drill-down, go back up without using the arrow

@HowtoPowerBI 2 года назад

you could create a bookmark and use that .. not sure why you would want it though

@joefromdc 2 года назад

@@HowtoPowerBI thanks for the reply. I created a clear all button using book marks

@karinbeyaert9950 Год назад

Great video. But why ad music to make it more difficult to understand what you are saying?

@CaucasianEU Год назад

but you don't show how to add this drill down button,

@DeronHuskey 2 года назад

Good explanation! Thank you. But, I gotta say, the drill at the beginning was Hee Haw level of corny :)

@rewinwilson6021 3 года назад

Im not gay but id still marry you becoz your videos are simply awesome. Its amazing how you take us through power bi and it it always amazes me how well thought power bi is....great video buddy and really great explanation...youve touched on the bare minimum which makes the most impact..... Please dont stop.....Is there a way i can reach out to you if i need help on power bi?

@HowtoPowerBI 3 года назад

haha this is already my favorite comment of the year 🤗😀 .. of course bas.dohmen@datatraining.io