Video není dostupné.
Omlouváme se.
DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL
Vložit
- čas přidán 6. 08. 2024
- 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 CZcams: 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
Extremely well done. All aspect of drill down, up, ... and drill through were well explained. Thanks so much for sharing this video.
Brill !!
Lot of concepts in one video ..
Thanks 👍
This is the best what I have seen so far
This is great, thanks for the great content!
Great content and very useful👍Thanks!
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
Easily the best power bi tutorials in CZcams. They’re crazy good.
Great video. Very very explicit. Thanks so much for this. Looking forward to more amazing content
Thank you! More to come!😀
This is really good. I have been looking for this information. You explained it in very detail and in easy way. Thanks a lot
U r awesome man... Thank you
Wow!! So simple and insightful
Great video. You have covered up all the important features related to Drill down and Drill through. Thanks! 🔥
happy to hear 😀 thanks!
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.
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?
I should have watched this video WAY earlier! Excellent explanation :)
Excellent content... Thank you so much, this is quite useful!!
so nice to hear, thank you!😀
Really good vid. Thank you. Subscribed.
awesome, Thanks for the sub Bhim! 😀
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
Very clear! Thanks
thx for watching Fra 🙂
Thank you very much for the video
It was easy to grasp
Glad to hear that Anam!
I have to say I am loving your videos!
Thanks Matias!
I've finally I learned what that Drillthrough button is for. Thanks a lot. Great explanation
thank you!
Best explanation ever! Thank you for this. 🙂
thank you Melanie! 😀
You are the MASTER-DRILLER dude! Thank you very much! :D
Hahahah thanks?!!! ;)
Thanks man. Can we drill through a table entry?
Thanks
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
thanks for the sub and welcome to our channel!
Thank you for the demo! :)
Thx for watching
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?
Excellent Explanation about this feature.
Samantha, I am glad it was helpful! :)
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?
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?
great
Yes. Great. Thanks a lot
happy to hear it was helpful :) Let us know if you have any questions or requests for upcoming videos
Great information..Thank you..please upload more videos..
thank you! definitely will :)
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
Thanks. The creation of product hierarchy is a bomb for me. I love it. More grease
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)
@@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
Great explanation!
thanks! :D
Is it possible to use drilldown for the legend in a line chart?
Great video!
Powerful stuff. 1st video was June 2020 yet so impressive. We will be following this channel closely. Where have you been?
doing my best :D , happy to hear you like it! more powerful stuff coming ;)
Thank you 😊😊
You are welcome 🤗:)
thank q
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
My new Fav channel
thank you so much Kátia, happy to hear!!! 😀😊
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 ?
excellent
Thanks Mihaela
when I drill down, am i able to regroup the data by month? e.g. Jan of 05/06 showing side by side?
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 :)
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
@@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 .
@jamie, were you able to find a solution for this ..
Good one
thx Smeet!
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
thx for pointing it out! should be fixed now! 🙂
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 ?
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: czcams.com/video/x64KFTbk4Yc/video.html
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
Very well explained.
thank you!!! 😁
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?
Thanks -
you are welcome George!
Should we enable drill through in the details page visual or in the main page visuals for this to work??
Details
Awesome video
Can u do video on powerbi service
Yes, it is on my list 🙂
Good explanation
Thx Praveen!!! 😀
👏🏻👏🏻
Please create a video on how to do Hyperlink drill through, mean that we will no need to right click and drill through
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?
yes, just place the dimensions on the visual (for example all on rows in a matrix) and you can drill / expand down.
Can you make a video of how to create your reset all filters (the icon you have on this report) Thanks in advance!
already have it 😁 czcams.com/video/_HTF7Ph7Eqc/video.html .. min 3:02 ...
@@HowtoPowerBI you are the man !
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.
Hi Jane, that's what happens when you turn drilldown on,.. no? 🙄
@@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 :)
How do you drill trough from a slicer :), the bar chart cannot go to the next level in a hirarchy. Correct?
Excellent video. I was wondering if there is a way to drill through cross reports using a button rather than having to right click?
Here you go
czcams.com/video/I7oyyb0Y8Oo/video.html
Where is the data csv being used?
Good job, I have a request, could increase subject screen and reduce yours? Thanks ;)
Thanks Normand 😊 . Considered it, but will be sticking with this format for now
Right Click on any bar and you can Drill down
How do you clear the drill-down, go back up without using the arrow
you could create a bookmark and use that .. not sure why you would want it though
@@HowtoPowerBI thanks for the reply. I created a clear all button using book marks
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
Great video. But why ad music to make it more difficult to understand what you are saying?
Good explanation! Thank you. But, I gotta say, the drill at the beginning was Hee Haw level of corny :)
but you don't show how to add this drill down button,
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?
haha this is already my favorite comment of the year 🤗😀 .. of course bas.dohmen@datatraining.io
Weapons shouldn't be shown on this...oh wait... OK, you're good.
hahaha :)
Why are You hiding details so quickly? [0:56] have pick of users checking this, not becouse it is very hard, but it was hidden to quickly.
don't see how this is quick .. just set speed to 0.5x
unclear
Why?
First of al your excel is weid af! so it didnt help with the lay out
😂that's because it is power bi not excel lol