How to use Drill Down in Power BI | Microsoft Power BI for Beginners
Vložit
- čas přidán 8. 09. 2024
- In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to use Drill Down in Power BI.
Download Microsoft Power BI: powerbi.micros...
Download Apocalypse Dataset: github.com/Ale...
Favorite Power BI Courses:
Power BI for Business Intelligence - bit.ly/3Nfi59i
Power BI A-Z - bit.ly/3MkpYKw
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Analysis and Visualization- bit.ly/3hhX4LX
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
🙌Patreon Page - / alextheanalyst
💻Alex The Analyst Shop - teespring.com/...
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
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.
Thank you for this ❤️
This new series is really flowing. My best teacher. Thank you
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.
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!
It is easy for data analysts to control the drill down but business users always gets confused about it.
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!
So great to hear! Thanks for watching!
Your videos are fantastic! But I need to know something after watch them... Are you a prepper?
Thanks so much Alex.. Making it simple for the past 3 weeks..
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!
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).
Thanks Alex very well explained
Thank you Alex you have an amazing way of teaching simple and very informative. I appreciate your efforts.
this was really cool, thanks, great series
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
Same
The visual has up and down arrows to drill up and down. Just click the up arrow.
Is it possible to drill down in a "Table" visual? or does it have to be a histogram?
Immediately subscribed.
Thank you so much for that, you really made efforts for us.
Thank you 🙂
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.
Don't try to open them in GitHub - just download them to your local computer and open them there - that may be the issue
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!
Thank you so much alex sir....
Awesome tutorial, thank you!!!
thanks
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.
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.
Thank you Alex
Very useful.. Thanks
Excellent
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!
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.
@@AlexTheAnalyst But do YOU have a certain preference? Just curious :)!
@@JW-pu1ukI think it’s power BI from the way he responded 😂
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?
you can disable summarize, by clincking on the field
@@TijarsView It makes it into Count. Which we are not interested in.
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
Hey. When I download the data, I do not see the purchase tracker table in it.
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!
i have the same , i wonder why it put's the Customer's name before every ID. May's The yaxis unreadable
Hey Alex, the "Price" is either showing as "Sum of Price" OR "Count of Price". How do I get only 'Price'?
Hey, it's happening to me as well, did you manage to figure it out?
@@rahimamalik9302 Hey, you have to choose the 'Don't Summarize' option in Column Properties, which can be found in the Data View Field.
@@sohrabkhan9590 I did it but still facing the same problem.
@@sultanurrahmanshuvo do a right click on the field that has been summarized and then choose don't summarize
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
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?
How can it be that your bars are always sorted in descending order?
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.
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?
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
@@el_rodo14 Thanks, great fix
i keep getting sum of price in the visualizations instead of just the price values, please how do i fix this?
same, sometimes I'm able to fix this in format, axis, value=select none
'Don't summarize' option
@@brunacabreramelgar4018 do a right click on the field that has been summarized and then choose don't summarize
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?
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.
What is going on everybody..what is more consistent 🔥
Done
How it gonna take to become a data analyst for someone has no experience in data field at all ?
Check out my video "How to become a data analyst with no experience" :)
Is it math important to be a data analyst?
Yes unfortunately
DAX made me sad....but Drill Down in Power BI seems more straight forward and quick than Tab.
why did DAX made you sad?
@@sleepdeprived9181complex I assume
First
@@nirali227 third