How to use Drill Through in Power BI. 👆 ONE click from chart to details

Поделиться
HTML-код
  • Опубликовано: 3 янв 2025

Комментарии •

  • @LeilaGharani
    @LeilaGharani  2 года назад +12

    Ready to learn Power BI? Start creating reports today! 👉 link.xelplus.com/yt-c-drill-powerbi-starter
    It’s simple, fast, and perfect for beginners-no jargon, just results!

  • @adlaalnajmi9162
    @adlaalnajmi9162 2 года назад +2

    I am only 5% through the BI course, and I started building reports. This is great

  • @shoboyjr
    @shoboyjr Год назад +1

    You're a star!!!! Thank you very much!!!!!

  • @noruwajoshua7066
    @noruwajoshua7066 Год назад +1

    I never understood Drill Through like this before. Thank You!

  • @vijayarjunwadkar
    @vijayarjunwadkar 2 года назад +10

    Hi Leila, I am learning these features through your Power BI course, but still enjoying these videos as well! Thank you! And congratulations on getting 2M+ subscribers! Way to go, all the best! 😊👍

    • @LeilaGharani
      @LeilaGharani  2 года назад +2

      Thank you, Vijay. I'm checking your progress % in the course every day 😜

    • @vijayarjunwadkar
      @vijayarjunwadkar 2 года назад

      @@LeilaGharani Please do check, as it will prompt me to be more dedicated and complete the course in time! 😁

    • @msateeshkumar6902
      @msateeshkumar6902 Год назад

      ​@@vijayarjunwadkar Hi Vijay
      I want her course

  • @CBrown
    @CBrown 2 месяца назад

    I'm new to PowerBI and recently discovered this channel. Of all the ones I've checked out, very few offer the same level of quality content, particularly in how well it's presented, as this one does. Well done.

    • @LeilaGharani
      @LeilaGharani  2 месяца назад

      Thank you for the kind feedback! 🙏

  • @chh8860
    @chh8860 2 года назад

    'Thursdays With Leila' back again! ... 👏👏👏 ...
    Leila's P-BI "appetizers" are sooooo tempting ... but not so good for someone with ADHD, i.e. "OMG ... look at THIS! ... Oh WOW!!! I can do THAT? ... OH, what's that for? ...COOL!!! ... VERY COOL!!! ... OMG, look over HERE!!!! ...". I salivate at the thought of the full meal (i.e. P-BI course), but alas it will be a while before I can sit at the table and focus ...😟 ... but when I do, I now know there will be a 'piece of cake' along with the meal ... 😋.
    Thank you ... thank you .... thank you ... 😍 ...😍 ... 😍

    • @LeilaGharani
      @LeilaGharani  2 года назад +2

      🤣 Yes - we're nearly back - except next Thursday. Our team is off recovering from the Power BI course. But after that we should be back to our weekly dates. It's a good thing I'm having coffee and cake (what they call in German a "Mohnkuchen") as I'm reading your comment 😋

  • @dayem9557
    @dayem9557 Год назад +1

    Focused and clear ... Thanks Leila 👌

    • @DavidShaw-dc4re
      @DavidShaw-dc4re 5 месяцев назад

      No it isn't clear. How does the first page relate to the drill through page. What is the data source form the first page and which field is the foreign key to the Stores table on the second page. I watched this video and she clicks fields willy-nilly and there is no visual clue on how any of these values relate to each other. This is entertainment not education.

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 2 года назад

    Though I don't use Power BI in daily job but learning this drill-through functionality is master tip

  • @MarwanAShareef
    @MarwanAShareef 2 года назад +3

    As always, Amazing 👏

  • @GodGladiator1
    @GodGladiator1 Год назад

    your videos on excel and on power Bi have helped so much thank you!

  • @reynaldomorillo4271
    @reynaldomorillo4271 Год назад

    YOU, ARE, AMAZING .... !!!! Thank you for all your, so clearly explained videos !!!

  • @StefanoGallucci
    @StefanoGallucci Год назад

    Very well done Leila!

  • @FadliBKL
    @FadliBKL 2 года назад

    Congratulations Leila.
    You have make my life easier. I am progressing with you since excel 👏🏻👏🏻👏🏻👌🏼 thank you…

  • @meredithleonor5035
    @meredithleonor5035 Год назад

    thanks for sharing looking forward for more power bi tutorials

  • @vikasvachheta7135
    @vikasvachheta7135 Год назад

    Really usefull video....valueable & more understanding way.

  • @immanuelhedimbi7066
    @immanuelhedimbi7066 2 месяца назад

    You've simplify this for me. Thank you so much. I like your sense of humor too. "A few moments later"

  • @SteveCamilleri
    @SteveCamilleri Год назад

    Excellent explanation. Thank You

  • @arbazahmad7177
    @arbazahmad7177 2 года назад

    Thanks for this Drill through features of Powerbi...

  • @giorgidvali951159
    @giorgidvali951159 2 года назад

    Another super useful video from super lady.

  • @StopWhining491
    @StopWhining491 Год назад

    Moves along fast for a beginner, not the speed so much as what user needs to know before viewing. Good info, through, for an intermediate level user.

  • @stefansappart4859
    @stefansappart4859 2 года назад

    Wow. The button is a very good idea.

  • @TheSterg98
    @TheSterg98 Год назад

    Thank you Leila!

  • @mohammedlabeeb
    @mohammedlabeeb 2 года назад

    Love love this feature

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

    Thanks for your time and support

  • @AUXA_2014
    @AUXA_2014 2 года назад

    Share for sharing, very clear explanation.

  • @TTeamFan
    @TTeamFan 2 года назад

    Best explanation I've seen so far :)

  • @merewatube8908
    @merewatube8908 2 года назад

    Thanks Lelia for your nice presentation and congratulations for surpassing 2M subscribers!

  • @woljin
    @woljin 2 года назад

    I love how you say "let me show you". This does take an effort to predict operations needs but overall I love this tutorial. I have not really used the drill through options in power bi but I have added links to details pages in a similar fashion. I think this method will improve my methodology. Thank you so much for the insight and keep up these videos. You really have your finger on the pulse of what operations will desire from these tools and explain it very well. Love the videos! 😊

  • @samniengpollong7841
    @samniengpollong7841 2 года назад

    Always very useful and helpful. Thank you so much....

  • @rajsahu1029
    @rajsahu1029 2 года назад

    Congratulations to crossing 2M

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

    Alt F12 and the third One. Very useful, without a doubt. Thank you for the tips...

  • @chrism9037
    @chrism9037 2 года назад

    This was great thanks Leila and congrats on hitting 2MM!

  • @lolosan7522
    @lolosan7522 2 года назад

    Hello Leila, thank you so much for the bonus tip. 😀

  • @Patiencelad
    @Patiencelad Год назад

    Great stuff. Thank you!

  • @NatishaM-tr9rl
    @NatishaM-tr9rl 7 месяцев назад

    Thank you Leila!

  • @honnurswamy6292
    @honnurswamy6292 2 года назад

    Very useful tricks ...madam congratulations for 2 M subscribed...

  • @masoudnajafabadi895
    @masoudnajafabadi895 5 месяцев назад

    Thanks I really enjoy it !!!!👍👍👍👍👍

  • @Ocram-gnuhc
    @Ocram-gnuhc 2 года назад

    Thanks so much. So detail and easy to follow. I learnt drill through finally!❤

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

    Wonderful! Your explanation and presentation amazing... It helps a lot! Thank you!

  • @harshitdubey3768
    @harshitdubey3768 7 месяцев назад

    Thank you so much... With due respect, I love you❤and your work

  • @DEEPAKKUMAR-ij7hw
    @DEEPAKKUMAR-ij7hw 18 дней назад

    the bonus tip was very helpful

  • @akkulkarni9495
    @akkulkarni9495 12 дней назад

    Thanks a lot❤

  • @torbenchristiansen5411
    @torbenchristiansen5411 2 года назад

    HI Leila - Really smart 🙂

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

    Very usefull! Making my life a little bit easier. Thank you.

  • @ngocthamnguyen4018
    @ngocthamnguyen4018 5 месяцев назад

    Thank you so much, this video is really helpful 🤩🤩

  • @EDF_FANatic
    @EDF_FANatic 2 года назад

    Great design 👌

  • @prakavids
    @prakavids 2 года назад

    Excellent tutorial.

  • @jacdragan8918
    @jacdragan8918 2 года назад

    Wow! You are good!

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 2 года назад

    excellent, thanks for sharing

  • @harshadhardas1648
    @harshadhardas1648 Год назад

    Thank you , it was helpful

  • @henryhenshaw2386
    @henryhenshaw2386 3 месяца назад

    Great job, weldone and thank you.

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

    Really helpful thanks for this video!

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 2 года назад

    That is awesome. THanks for the share.

  • @dnyaneshwarmanjul7363
    @dnyaneshwarmanjul7363 8 месяцев назад

    thanks, you made my work easy by explaining this functionality.

  • @eli.jiah.meowmeow
    @eli.jiah.meowmeow 9 месяцев назад

    Good stuff! Thank you

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

    Love your videos! Thanks!

  • @oumarbalde8312
    @oumarbalde8312 Месяц назад

    thank you it's very usefull

  • @alsulaiti
    @alsulaiti 2 года назад

    Amazing ! Thanks

  • @jessontvarghese327
    @jessontvarghese327 Год назад

    Awesome 👌

  • @sonhpt4887
    @sonhpt4887 2 года назад

    Thank you so much

  • @karljolivet5991
    @karljolivet5991 5 месяцев назад

    Wow you always explain clear and easy. Mnay thanks

  • @jacobddavis5916
    @jacobddavis5916 2 года назад

    Amazing content, Amazing narration and explanation!

  • @prakashkulkarni1013
    @prakashkulkarni1013 Год назад

    This is great. Thank you for enlightening us on this feature. How will this work with Parameterized values?

  • @TheWeltanschauuung
    @TheWeltanschauuung 5 месяцев назад

    as always, this is awesome

  • @nguyenngothuong
    @nguyenngothuong Год назад

    MANY THANKS

  • @taizoondean689
    @taizoondean689 2 года назад

    Thank ma'am 🙏🙏

  • @bidyutgogoi9346
    @bidyutgogoi9346 Год назад

    You are awesome. Thank you for sharing informative videos like this.
    Could you also advise how to clear the filter once drill through filter is applied?

  • @2008davidvieira
    @2008davidvieira Год назад +5

    Hi Leila, I've been following your amazing work for some time now and it has been very important to me.
    That said, and regarding this topic (drill through) I would like to ask a question:
    I have found drill through examples only with charts, however I wonder if it applies to tables? i.e. I have a table of summaries (e.g. order forms) but I would like to see more details (the respective articles) by drilling through.
    I hope you can help me.
    Thank you!

  • @bxg81123
    @bxg81123 2 года назад

    it’s just awesome 👏

  • @usernamemoo
    @usernamemoo 19 дней назад

    Impressive video quality, congratulations! :) :)

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

    That's a very good video for making it understand

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

    Great Video.

  • @laptops869
    @laptops869 8 месяцев назад

    Thank you for this useful video it helped me

  • @MsAPEKSHASINGH
    @MsAPEKSHASINGH 5 месяцев назад

    thanks for the video! super helpful! A query though - is it possible to retain selection of chart (in this case) when we go back to main page from drillthrough page using back button

  • @sugathmudalige1265
    @sugathmudalige1265 2 года назад

    Great👌

  • @sserubiricedrick9874
    @sserubiricedrick9874 2 года назад

    Thank you so much for the good work, we really appreciate it.
    Kindly create for us Introduction to python"lessons as well.

  • @Chaisamachai
    @Chaisamachai Год назад

    Thank you

  • @hassansafieddine5286
    @hassansafieddine5286 2 года назад +1

    Hi Leila, great work as always, can you make a video of how to add offline maps, and add coordinates to these maps... Thank you

  • @beinspired2k
    @beinspired2k 8 месяцев назад

    thanks leila

  • @ryanmessier9243
    @ryanmessier9243 6 дней назад

    Cool video... can you share the example source sheet so that i can follow along?

  • @thedragonmaster458
    @thedragonmaster458 Год назад

    Happy new Year…thx for sharing another amazing video…there is no drill through option when I right click…what did I do wrong 😢?
    Many thanks for any tips in advance…

  • @albertinogulube4734
    @albertinogulube4734 2 года назад

    Perfeito! muito útil.

  • @AkhtarHussain-ct2hr
    @AkhtarHussain-ct2hr Год назад

    Excellent work, may I suggest that you add some transparency to your mouse pointer, as its sometime difficult to follow which button you clicked specially for visual impaired.

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

    Super helpful!! One additional question. After watching your video, I made a drill through report to a page that shows me the underlying claim details for a given doctor. The claims detail are show in a matrix table, that has a date hierarchy of (year, month, day). When I do the drillthrough, the hierarchy is always collapsed, but I'd prefer to have the hierarchy always expanded when I drill through. Is this possible? Thanks!

  • @negarsattarzadeh7324
    @negarsattarzadeh7324 Год назад

    well done girl

  • @IslamAhmedMohammedElShamaa
    @IslamAhmedMohammedElShamaa 2 месяца назад

    Great!

  • @kalpeshpatil5959
    @kalpeshpatil5959 2 года назад

    Great Video. THANKS FOR SHARING.
    Let me know if any course on BI

    • @LeilaGharani
      @LeilaGharani  2 года назад

      Glad you liked it. We just launched a Power BI course: courses.xelplus.com/p/fast-track-to-power-bi

  • @hemvaidya
    @hemvaidya 2 года назад

    amazing

  • @banasaikrishna420
    @banasaikrishna420 Год назад

    Great Explanation on Drill through Function.
    I have a query,
    Just by clicking on Pie chart/bar chart--It has to show corresponding detailed tabular information in another page(it has to perform Drill through function and navigates to different page by one click on bar)
    instead of going with button option(or selecting bar->right click->drill through->selecting page) or without using Drill through selection page.

  • @sarikavaidya6681
    @sarikavaidya6681 2 года назад

    Pl continue with next power bi lesson

  • @bharatasanani6827
    @bharatasanani6827 2 года назад

    Intersting..

    • @jbs1225
      @jbs1225 2 года назад

      Great! Can this bottom click to select customer details only?

  • @gralle1808
    @gralle1808 5 месяцев назад

    this works great, the only issue i have is with the details button that you have shown sitting on top of the bar chart visual. Even if i format this button to be at "the front", once i've clicked on the bar chart visual which enables the "more details" button, I need to click away first before i am able to click the button to drill through. If i don't do this i am just clicking on the bar chart visual again disabling the button. Any tips?

  • @abbashuzefamotiwala
    @abbashuzefamotiwala 3 месяца назад

    Hi Leila, could you please show us, either through a video or by replying to this comment, how to add dynamic text in the button/shape as demonstrated in the last few minutes of the video? Thanks!

  • @velu1386
    @velu1386 Год назад

    Thanks for your informative video, however could you please assist me to show the details of another query fields when I click details.

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

    Are you able to hide the drill through page on the desktop app and still go to it on the web version?

  • @Jakeu1701
    @Jakeu1701 2 года назад

    Pivot, Pivot Charts, and Slicers. Easy to do in Excel.

    • @ntimikk
      @ntimikk 2 года назад

      Can you create a dash board such that it can drill through?

    • @Jakeu1701
      @Jakeu1701 2 года назад

      @@ntimikk slicers and other filters to get criteria, have a pivot tied and double click on numbers to drill down. Most of my reports do this and not a dashboard.

    • @ntimikk
      @ntimikk 2 года назад

      @@Jakeu1701 thanks will give it a try

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

    How about clickable drill throughs of table values?

  • @andree2000
    @andree2000 3 месяца назад

    Very interesting, but is is possible to create drill through page which shows you all countries in one table?

  • @AKhan-nu9mw
    @AKhan-nu9mw 2 года назад

    thanx