How to use Drill Down in Power BI | Microsoft Power BI for Beginners

[@sj1795]

I really see the value of using drill down--saves time and space (don't have to do as many separate visualizations). As always, THANK YOU ALEX!

[@lemuelrobert5869]

This new series is really flowing. My best teacher. Thank you

[@nimrod4463]

For those who have the updated PowerBI version here is what you need to do in order to see the visualization in the order that is shown in this video: Go to the three dots on the frame of the visualization -> Price -> Sort Descending and unmark the Sort Legend. Now it is ordered correctly. On why it writes "Sum of Price", it's probably because of an Update for PowerBI Desktop Version, For that you can just rename it :"Price" on the field itself. It has the same data.

[@joyudoh8224]

Thank you for this ❤️

[@blessingchikumbirike8709]

Thank you

[@icecreamsammich_head]

I was just going to leave a comment to figure this out and this was the first thing I saw -- thank you so much!

[@juliodiaz1756]

Hi, Alex, I would like to congratulate you for putting so much effort into these high-quality free videos. I'd love to know if you plan to do "intermediate" PowerBI Tutorial series. Or if you have a course in Udemy it will be great.

[@danfranfit]

I enjoy that you are smiling as you speak in the beginning. It makes your videos and you as the teacher feel very approachable. Great EI!

[@Peep_007]

Thank you Alex you have an amazing way of teaching simple and very informative. I appreciate your efforts.

[@felixc.programs8209]

Always love your new videos! I hope to help more people one day by having a wider reach like you, so your content motivates me a lot. Cheers!

[@AlexTheAnalyst]

So great to hear! Thanks for watching!

[@bagusaji2839]

Hey Alex, i have a problem with drill down. Im tryin to follow your bar chart until on minute 5:05, when i doin the drill down then click one of the customer, the Y-axis is goin to be "Uncle Joe's Prep Shop 7616", so i can't see the order id. any recommendation to solve this? Thank u so much Sir!

[@olamidegaffar7269]

i have the same , i wonder why it put's the Customer's name before every ID. May's The yaxis unreadable

[@akintimehinmoromoke]

Thanks so much Alex.. Making it simple for the past 3 weeks..

[@nakulsharma409]

this was really cool, thanks, great series

[@shauryabahl579]

1:52 Hey Alex Sir, In my case whenever I drag down "Product" option in x-axis, it is by default drilled down even though I've tried to do it multiple times.... Is it because of the updated version of Power Bi that I've installed from Microsoft Store or it could be something else?? Please help

[@nimrod4463]

Same

[@DataMatrix0101]

The visual has up and down arrows to drill up and down. Just click the up arrow.

[@nestormartire5305]

Your videos are fantastic! But I need to know something after watch them... Are you a prepper?

[@elliot_bromberg]

Is it possible to drill down in a "Table" visual? or does it have to be a histogram?

[@mattworld8752]

Immediately subscribed.

[@lakshmivaishnavi7547]

Hey. When I download the data, I do not see the purchase tracker table in it.

[@the_Brus]

Nice but shallow. I would like to see more complex things. Like grid with few aggregations (eg. 3 cols) and drill down to show all unique details under it (eg. 10 cols).

[@maryamfatima5882]

Thank you so much for that, you really made efforts for us.

[@sleepdeprived9181]

It is easy for data analysts to control the drill down but business users always gets confused about it.

[@katherineeeeeeeeeeeeee]

Hey Alex, Loving this series but have a question.. Whenever I click/ drag one of the fields , it renames it into "Sum of "[field name], This happened in the DAX video as well. How can I change this?

[@TijarsView]

you can disable summarize, by clincking on the field

[@nimrod4463]

@@TijarsView It makes it into Count. Which we are not interested in.

[@ExcelTutorials1]

Awesome tutorial, thank you!!!

[@Wazy_E]

Thank you for this. I have a question though. What does this legend mean exactly? when creating charts, because i noticed that once you drag an item to the legend, it displays in differ colours.

[@nnamdiLdavid]

Thank you Alex

[@paulinusudoh3474]

Hello sir, thanks for your videos. I'm learning quite a lot. Please, I'm having a challenge downloading your datasets for all the Power BI tutorials. I keep having errors opening them all.

[@AlexTheAnalyst]

Don't try to open them in GitHub - just download them to your local computer and open them there - that may be the issue

[@paulinusudoh3474]

Thanks a lot sir. It worked! I'm really learning a lot from your videos from Tableau, Power BI, SQL and Python to upgrade my skillset. God bless you!

[@behnoud_alg]

I get count of customer and sum of price when I drag customer and price in Y-axis. How can I just insert customer and price?

[@adnanadjk9960]

Thank you 🙂

[@sohrabkhan9590]

Hey Alex, the "Price" is either showing as "Sum of Price" OR "Count of Price". How do I get only 'Price'?

[@rahimamalik9302]

Hey, it's happening to me as well, did you manage to figure it out?

[@sohrabkhan9590]

@@rahimamalik9302 Hey, you have to choose the 'Don't Summarize' option in Column Properties, which can be found in the Data View Field.

[@sultanurrahmanshuvo]

@@sohrabkhan9590 I did it but still facing the same problem.

[@petersultan6251]

@@sultanurrahmanshuvo do a right click on the field that has been summarized and then choose don't summarize

[@brzarchitect]

@@sohrabkhan9590 there is no option saying "dont summarize" :(

[@yashmalode5331]

Thank you so much alex sir....

[@vamsiharati3206]

Very useful.. Thanks

[@mikefranko2832]

How can it be that your bars are always sorted in descending order?

[@DPEART6475]

In the chart, you will see 3 dots in the upper right. Tap on them and then go to Sort Axis , hit Sum of Price and Sort Descending and this will get your chart organized in Descending Order.

[@frybait0626]

Can drill down be applied to other tables? For example. in this video the Apocalypse Sales and Purchase Tracker tables don't have any relationship, I want to drill down for Units Sold in each product for each store the the Units Sold column is in another table. Does drill down can still be applied even if the next level is on the other table and the first level is on another different table?

[@frybait0626]

Also, if I try to establish a many to many relationship via Product and Product ID between the two tables, I couldn't produce a Visualization.

[@el_rodo14]

So when I create the second graph, when I go down one level, the name of the customer stays on the label along side the order ID instead of just showing the Order ID. Does anyone else have this issue? If so, could you fix it?

[@el_rodo14]

So Im not sure it can be called a fix but the graph is now working as intended so I'll roll with it. What I did was switch to the vertical bars version, in the X axis I turned on Concatenate labels, switched back to horizontal bars and now it was only showing the order ID when going down one level

[@BigWatersBand]

@@el_rodo14 Thanks, great fix

[@SameerShaikh-wv1qp]

Excellent

[@JW-pu1uk]

Thanks for this, Alex! I would like to know if you have a preference towards PBI or Tableau? I have used Tableau for 3 years but have a job offer and they use PBI!

[@AlexTheAnalyst]

Both are great options - I generally recommend people learn Tableau since it's a bit easier to learn in my opinion, but both are good.

[@JW-pu1uk]

@@AlexTheAnalyst But do YOU have a certain preference? Just curious :)!

[@TeliahTalksData]

@@JW-pu1ukI think it’s power BI from the way he responded 😂

[@brzarchitect]

@@AlexTheAnalyst tableau is much less user friendly

[@osiomogieasekome8799]

i keep getting sum of price in the visualizations instead of just the price values, please how do i fix this?

[@brunacabreramelgar4018]

same, sometimes I'm able to fix this in format, axis, value=select none

[@Test123-s7u]

'Don't summarize' option

[@petersultan6251]

@@brunacabreramelgar4018 do a right click on the field that has been summarized and then choose don't summarize

[@josephsatow482]

Why does my PowerBI default the title to 'Sum of Price by Store, Product, and Product' when yours just defaults to 'Price by Store and Product'. Similarly, my Y-axis defaults to 'Sum of Price' and yours defaults to just 'Price'

[@scstudios8]

I find people do NOT want to drill down. They rather want a tab at each level where they have filters they can set that vary by level. When I do drill down, people always say, can you just make that level as a tab where I can have controls at that level. Total, sub total, then sub sub total, it always seems better than drilling into the different levels. The key is, the filters change at the lower levels and you simply gain more filters. This seems to be WAY more intuitive and I never get requests for drill when people see the levels on tabs. If the records are not massive, I can have the last tab be full detail so people can do anything on their own in some other tool with the raw data.

[@ashourmio7182]

Hi Alex, you said in one of your videos about the importance of recruiters if you are in the middle of nowhere and looking for a job, the problem I have is that I am not a US citizen. Almost every job response that I get is that they can't hire noncitizens, what should I do, and are there recruiters for the global job seeker? Thank you very much

[@SeattleDataGuy]

What is going on everybody..what is more consistent 🔥

[@yokiofficial7596]

thanks

[@AkhtarHussain-ct2hr]

Please please... highlight your cursor, so it can be seen what you are pointing at. some us do not have good sight to follow the tiny cursor. thank you

[@abrarrmehat8040]

Is it math important to be a data analyst?

[@TeliahTalksData]

Yes unfortunately

[@TragicGFuel]

Depends on how good looking you are

[@abdilwahidmahmoud4017]

How it gonna take to become a data analyst for someone has no experience in data field at all ?

[@AlexTheAnalyst]

Check out my video "How to become a data analyst with no experience" :)

[@emadbaghernia2325]

❤❤❤

[@brzarchitect]

there is no option here to not Summarize

[@TravisTraps]

DAX made me sad....but Drill Down in Power BI seems more straight forward and quick than Tab.

[@sleepdeprived9181]

why did DAX made you sad?

[@TeliahTalksData]

@@sleepdeprived9181complex I assume

[@samuelraj5613]

Done

[@chaitanyakhare1869]

compeleted 12 December

[@fayezhesham1057]

First

[@AlexTheAnalyst]

@@nirali227 third