No video :(

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

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

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

50% 1

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

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

8 авг 2022

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@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 10 месяцев назад

Thank you for this ❤️

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

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

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

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!

@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 5 месяцев назад

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!

@felixc.programs8209 2 года назад

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 2 года назад

So great to hear! Thanks for watching!

@akintimehinmoromoke 3 месяца назад

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

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

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

@sleepdeprived9181 Год назад

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

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

Thanks Alex very well explained

@nestormartire5305 Год назад

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

@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.

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

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).

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

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!

@mattworld8752 Год назад

Immediately subscribed.

@maryamfatima5882 Год назад

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

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

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

@yokiofficial7596 14 дней назад

thanks

@ExcelTutorials1 Год назад

Awesome tutorial, thank you!!!

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

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.

@adnanadjk9960 Год назад

Thank you 🙂

@yashmalode5331 Год назад

Thank you so much alex sir....

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

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.

@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.

@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

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

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

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

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

@JW-pu1uk 2 года назад

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 2 года назад

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 2 года назад

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

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

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

@vamsiharati3206 Год назад

Very useful.. Thanks

@nnamdiLdavid Год назад

Thank you Alex

@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

@SameerShaikh-wv1qp 6 месяцев назад

Excellent

@AkhtarHussain-ct2hr 4 дня назад

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

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

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

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

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.

@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

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

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?

@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

@user-if7jq3gj7o Год назад

'Don't summarize' option

@petersultan6251 Год назад

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

@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.