Power BI Project END TO END: Full Development Course!!!

[@jerrylee520]

I love how you show me the model design. This is the best video from more than 20 videos of PowerBI tutorials.

[@PowerBIBro]

Thank you so much for sharing and I’m happy to hear you think this is the best video!!! Appreciate your support!!!

[@ArshadAli-rp2cn]

This project is really amazing , I haven't completed it yet but the incomplete dashboard looks beautiful. Really appreciate the hard work that you have put in this and provided for free. Just one suggestion , I am using an updated Power BI so many of visual formatting options have been relocated to some other option and it took a lot of time to find them and perform the operations, so maybe you can provide something for the new viewers to update them. Thanks anyway, looking forward to more such cool projects in the future .

[@PowerBIBro]

That’s a great idea and thank you!!

[@beavermuchichwa3628]

Excellent video, thanks for the walk through. How do I change the colour of the dot on the bar chart legend to red?, its still blue even though we changed the colour of the bars to red.

[@PowerBIBro]

Hey I can help with that! It's a weird quirk...here's what you'll need to do to set the legend bubble to red. 1. Temporarily Change the chart type to a standard bar chart (not line and stacked column) 2. Go to the Bars section 3. Select the series 'Avg Rating" and set the color to red - the legend should have now changed 4. Change the chart back to original (line and stacked column) chart This should set it!

[@maitrph]

@@PowerBIBro Phew! Thank you. Your reply has saved me the stress & time of trying to figure out this awesome trick. I guess the issue is due to the conditional formatting of the column color "confusing" the automatic matching color of the legend marker.

[@PowerBIBro]

Happy to help!!

[@mohammadafreen2390]

​@PowerBIBro Thankyou so much! This dashboard is awesome & your tutorial too!

[@PowerBIBro]

Thank you!

[@alexrosen8762]

Amazing... really amazing. I learn so much from your tutorials and they are always up to date including working files som I can follow along 👌🙏👌

[@PowerBIBro]

Thank you so much!!!

[@VictorFinley-v8z]

It took me a while to figure out why my waterfall chart wasn't showing a gradient color scheme, but I figured out my "Model View: Cross-Filter direction" was set to single instead of both.

[@PowerBIBro]

You are very correct and great job figuring that out!!! I should have included that step in the video. Appreciate your support!!!

[@simonubi5009]

You don't know how this information just saved me the stress of trying to figure out how to solve same issue. Thanks

[@ceyhunozturk5115]

Mann.. thank you so much. i could not have figured out why it had not worked until i saw your comment

[@christianwiah4526]

I finished the Card Filter (clickable) and I was sold instantly. I haven't even started this comprehensive course yet but am excited already! Thank You!

[@PowerBIBro]

Thank you for sharing!!! Happy to hear that you love the clickable cards and are working through the videos!!!

[@suraganiradharani3572]

Have you finished the dashboard if yes. I stuck in the funnel chat where we will add tittle and rating group . In chat it shows titles and sum of rating but in dashboard it's shows titles by rating group . Can please help me with this problem 48:35 at this point I got stucked. Thank you in advance.

[@Zoubfvgus]

Hey❤ thanks for this amazing project, I am a aspiring Bi developer was wondering can I use this project in my portfolio?

[@PowerBIBro]

For sure! Thanks for your support and I’m excited for your Power BI future!

[@leosch80]

Hello Robert! I am really grateful to you. I have been looking for some good projects on youtube and yours is the best of them all. Congratulations! You helped me learn a lot about PBI. There is one thing that is still a bit confusing. I followed the video step by step, with all the filtering just as you did; and in addition to that, I've applied all the comments and answers below in this video, and I still didn't get to the exact number of rows. Nevertheless, I was able to finish the project without any problems. Thank you... Thank you... Thank you!

[@PowerBIBro]

I love this comment, thank you!! For the row count variance, the Kaggle dataset is continually updating. If you look at the dataset in the downloadable .pbix file, it is slightly different from the current dataset. Where did you get your dataset from? If you downloaded it the row count variances are expected. Thanks again for your support!!

[@romaindurand6341]

Thx a lot from France :) ! I loved your tutorial, you make it so fun. Keep it up

[@PowerBIBro]

Thank you for your support and for sharing this positive comment!!!

[@ranaasad6887]

Awesome so far. Your way of working is pretty organized and industry-level I must say! You're awesome and handsome Man!

[@PowerBIBro]

Wow, thank you!

[@karishmauma1196]

Hello sir , Im Karishma from Bangalore , India. Your power bi dashboard tutorial was sooo amazing for me to learn a lot of insights from your teachings. Thankyou sir..I love u❤❤

[@PowerBIBro]

Thank you so much for sharing and I am so happy to hear that you love it!!!!

[@dirtybzoo7549]

Pure gold, amazing video, project and explanation. 10/10 bro.

[@PowerBIBro]

Thank you!!!

[@myanyeinchan7984]

Simple and very effected . Thank you so much for your sharing.

[@PowerBIBro]

Thank you for your compliment!

[@nikhildhongade291]

Explanation was good, keep continuing making such videos.

[@PowerBIBro]

Thank you so much, I will!!

[@suyashlade25]

for waterfall model, i followed all your steps but i am getting same that is blue color for all,why so?

[@PowerBIBro]

Excellent question! This small step was missed in the video, if you check out some of the other comments you’ll find details around how to solve. At a high-level, if you go to your model and update the filtering to be bi directional it should fix the issue. There are also other workarounds if that doesn’t fix it! Thanks for your support and sharing your question!

[@Gallivanter_26]

Hello Robert, I am Pawan, aspiring Data Analyst, currently i am working as a .net full stack developer. I found your "Power BI Project END TO END: Netflix" Project video on youtube and i loved the dashboard design and the explanation. For my third power BI project i would love to work on this project provided by you and to increase the learning process i will make sure to bring up a new theme in the dashboard. After project completion, will it be okay, if i add the project on my linkedIn profile as post, and tagging you for the brilliant guidance you have passed to us. and Can i add this project in my resume to make my resume stronger and appealing? Thank you

[@PowerBIBro]

Hi Pawan! Thank you for sharing this compliment! You can absolutely add this project to your LinkedIn and share as you see fit! I appreciate any tagging and thank you for sharing! I hope this will help you land a job!!!

[@shivangrajpoot4240]

53:00 i am unable to link the color grading table with the chart gradient doesnt happening

[@PowerBIBro]

Thank you for this question and I can help! You'll want to update the relationship to bi-directional and it should fix it. If you scan the comments for this video you'll see the solution discussed in greater detail!

[@devineguster]

You are my hero, thank you very much for this piece of work

[@PowerBIBro]

I love it!!! Thank you for this amazing compliment!

[@mrcrblr850]

Brooo You are Amazing!! I want to Highlight the Organization of your MEASURES, i always do the same with my Dashboards, But You are in a different Level, Definitely Learned a lot of tricks, thank you for the great job and all the knowledge shared!!!

[@PowerBIBro]

Made my day!!! Thank you for sharing this positive feedback and I love keeping things organized!! Pumped to hear that you've learned a lot and glad I can help ~ thanks for sharing!!

[@nigammm01]

1:05 display units for the cards section is not showing , how to do that ?

[@PowerBIBro]

Hi thanks for your question! To get the display units for a detailed label on a card, you'll need to select a few items. Under reference labels, for 'Select series' choose the movie titles KPI. Then when you scroll down, for 'Select label', pick the desired label, then you can adjust the display units for that label. Hope this helps! You can get more detail on reference cards through this video as well. kzbin.info/www/bejne/joWvoGlqqN6Xmc0

[@TanmayDeochake-qb9qs]

Hello Sir this is Akshay from India. I completed this Project and many more by watching this video. It was very helpful & the way you Explained was Excellent. Thank you so much Sir.

[@PowerBIBro]

Hi and thank you for sharing!!! I am so glad to hear that this video was helpful!!!

[@madhan.mtammi4178]

Bro ... On the Calculation table you just showed how to create some measure like title, votes and AVG but when you started creating visuals I could see Movie , TV and Formating Folder under Calculations where are these come from you not shown how to create it :(

[@PowerBIBro]

Thanks for this question! You're totally correct, there are other measures and dimensions created which I did not detail in this video. I wanted this video to focus on using data vs prepping it. If you go to the transform layer (power query) you can view the multiple data cleansing steps I performed.

[@PowerBIBro]

If you have a specific field you're interested in, I'll be happy to give a summary about it

[@SandipanSarkar-c8v]

Finished watching

[@kirubelabiyu2021]

Can you help me here bro? The background color for the waterfall visual (titles by rating group) is not happening for me though I did everything as you did it.

[@PowerBIBro]

Happy to help, did you download the corresponding file from GitHub? If so, does it show the values as expected?

[@yuvakrishnathanneru9237]

Great tutorial!

[@PowerBIBro]

Glad you liked it and thank you for sharing!!!

[@hobbiesbyjulie]

hello, nice tutorial. I wasn't able to get the gradient coloring for the waterfall ratings chart. It still showed just red only

[@PowerBIBro]

Hey, check out the other comments for this video. A solution was posted by a subscriber, which I love! "In the Model view you should change the Cross filter direction from Single to Both, for the relationship Listings - Rating Group Formatting. Then you will get gradient colors"

[@hobbiesbyjulie]

thanks @@PowerBIBro

[@kenneth24castle]

That fixed it for me!!! Thanks@@PowerBIBro

[@PowerBIBro]

Awesome!!

[@manthanmistry1205]

Great video♥️. Just wanted to say can't we just use Round down (Rating s,0) instead of the whole switch statement??

[@PowerBIBro]

Great question! We could round down the rating to just a whole number via a DAX function, but the second part of the switch statement assigns the color to the value. So the benefit is that we only need to manage the color selections one time inside the switch statement. If we instead we were to round the number, then we'd need to also setup the color for each rounded number in the conditional formatting of the visual itself. The cool thing about Power BI is that there is usually many ways to solve the same problem :) Hope this helps and thanks for the comment!

[@growthcompanyus]

Dudee, you´re the best, Thanks for all the content you do.

[@PowerBIBro]

Dudeeee!!! Thank you sooo much! I really appreciate you commenting and sharing this!

[@sedeosazuwa7220]

Thank you, great job

[@PowerBIBro]

Thank you too!

[@carrey112]

Very well done. One small question. I didn't notice where you changed the blue tick mark in the column chart to red, and couldn't find it. Did you explain somewhere in the video and I missed?

[@PowerBIBro]

Very interesting! I was able to replicate the issue and have a fix for changing the blue tick mark to red. Try following these steps and let me know if it fixes the problem. 1. Switch the chart type to a standard bar chart (the bars will turn blue). 2. Set the bar color to red under the bars menu for 'Avg Rating' 3. Flip the bar chart back to Line/Bar chart and the legend marker should now be red vs blue

[@juiroy8924]

@@PowerBIBro workEDDD...

[@LawrenceYounis]

Thanks for everything, my only concern about power BI is only appearance, i want to beat that canva freezing sittings

[@PowerBIBro]

Thanks for watching!

[@khyatidesai247]

Hello Robert 26:35, I had PowerBI throw an error here : The search Text provided to function 'SEARCH' could not be found in the given text. After sifting through stackoverflow I randomly types : Genre = LEFT(Listings[Genres],SEARCH(",",Listings[Genres]LEN(Listings[Genres])+1)-1) (double commas after Listing[Genres] in Search) and it worked, I was wondering if you had an explantion for this? Thank you!

[@PowerBIBro]

Hi and thanks for the question!! It's a curious question as when I review the above DAX logic is seems incorrect. I pasted it into the project and confirmed the error. It seems to be missing a comma. Try the below logic, it should work exactly as expected. If the above logic worked for you I'm not sure how that's possible but glad that it did! Genre = LEFT( Listings[Genres], SEARCH( ",", Listings[Genres], , LEN(Listings[Genres]) + 1 ) - 1 )

[@hobbiesbyjulie]

Hi, please are we supposed to be getting a different value from the tutorial? I keep getting 5604 rows instead of 5501 in the tutorial

[@PowerBIBro]

Hi! Yes the row totals should match if you are loading the same data. Maybe check your data import steps to ensure they align with the tutorial and excel file. If you check the datafile itself directly in excel, how many rows does it have?

[@hobbiesbyjulie]

@@PowerBIBro The raw file i downloaded - netflix list - is 7009 rows on excel

[@PowerBIBro]

I gotcha, here's what you need to check out. There are a set of transformational steps happening in the power query which cleanse the data. If you open the netflix project file, go to 'Transform Data', select the "Listings" query, you'll see a step in the 'Applied Steps' section called "Filtered Rows". This step cleanses the data, if you review you should find the details you're curious about. pasted below... = Table.SelectRows(#"Renamed Columns1", each ([Genres] "\N") and ([Type] "short" and [Type] "video" and [Type] "videoGame") and ([Rating] null) and ([Country] "-"))

[@hobbiesbyjulie]

@@PowerBIBro I have noted my mistake. I should have gotten the dataset from the netflix project itself and not the kaggle netflix list

[@newincomprendidos]

I dont know how to change the AVG Rating Color in the legend. I followed all the steps but in your video, you still have the blue color in the legend. Minute 2:05:27

[@PowerBIBro]

Hey I can help with that! It's a weird quirk...here's what you'll need to do to set the legend bubble to red. 1. Temporarily Change the chart type to a standard bar chart (not line and stacked column) 2. Go to the Bars section 3. Select the series 'Avg Rating" and set the color to red - the legend should have now changed 4. Change the chart back to original (line and stacked column) chart This should set it!

[@adilabdulrazack1388]

52:52 I know this video is almost 6 months old maybe the feature was a new addition but still curious cant we use the 'Gradient' option from 'Format Style' for creating gradient instead of going through all this hurdles of creating a table and all?

[@PowerBIBro]

Love the question and thank you for asking it! You can apply the gradient option from format style but you'll notice an important difference in the color results. To test it out, apply the gradient option and use the value of # Titles. You'll see the gradient does apply, but it scales from highest 'VALUE' to lowest 'VALUE', so the color does not go from Top to Bottom like the applied levels. The scaling would function similarly to how the bar chart scales from high to low. Hope this helps clarify the difference!

[@commandersleepy]

Hello sir this was an awesome project. Still incomplete but i have a doubt. Is it normal for some movie titles to show show pictures? Thanks in advance

[@PowerBIBro]

Thanks for this comment and glad you're enjoying the project! Will you share a specific example of the mentioned movie title picture image issue? ... a specific example will help me to replicate the error and review the details.

[@commandersleepy]

@@PowerBIBro Thnx for replying..the thing I was talking abt is for ex breaking bad , Double Kara thers is no img shown. And another ex is in Go! vive a tu manera, meteor garden instead of poster abt the show it just shows that yellow black IMDb logo

[@PowerBIBro]

Yep that’s totally expected, it’s an error with the dataset provided and not an issue with power bi. Thanks for the details and for checking!!

[@commandersleepy]

@@PowerBIBro I see thnx for letting me know. Have a nice day sir .

[@Unseennoxi]

Thanks bro

[@PowerBIBro]

Thank you for sharing and my pleasure!!!

[@Unseennoxi]

@@PowerBIBro can you upload more project like this it will be really helpful for us

[@PowerBIBro]

@noxious8507 absolutely, on my list to create another full length project! Thank you for your support!!!

[@kebincui]

Excellent demo❤👍

[@PowerBIBro]

Thank you very much!!

[@devineguster]

My card image of 'Movies and Tv shows' Position Property is inactive. I cannot change the image to the left, any remedy? Thank you for this great peace of work

[@PowerBIBro]

If you download the file in GitHub does it work for you?

[@ThePilli41]

Howdy! Great toturial and walkthrough. I know this is just a demo, but I kinda think its not necessary to throw away columns so carelessly. Also would it not be better to unpivot the genre column? this way we only keep the ALPHABETICALTY first genre, losing the majority of genres...

[@PowerBIBro]

Great questions and thanks for the feedback! Removing the columns was intentional just to keep it focused on this demo, certainly a good practice to keep all applicable columns your end users may need. I also like the genre idea, to expand on it, I’ll create a separate “genre” table which splits all the comma separated values into rows, then we can count every possible genre a title is allocated to (one to many) Thanks for the ideas and feedback!!

[@2018MANOJ]

Really Its Helpful was easy to follow and learn, Thanks a lot for this Video!! ♥♥♥

[@PowerBIBro]

Thank you very much!!

[@kdausu90]

Nice work!

[@PowerBIBro]

Thank you!

[@balaroxx2700]

#votes per title =round(divide(#votes,#titles),0) if somebody looking to calculate this 2:08:02

[@PowerBIBro]

Thanks for sharing!!!

[@sedeosazuwa7220]

I'm not sure what I'm doing wrong the Gradient is not working I only get a red colour

[@PowerBIBro]

For the gradient, are you creating it in Power Point? Gradient backgrounds are not within PBI, but to obtain a gradient background perform the following. Change the background of a ppt slide to a gradient color, save that as an image, then add the image as the background to the PBI canvas. Within power point, the background settings are under the format section if you right click on the background.

[@miljenko-vv3vb]

In the Model view you should change the Cross filter direction from Single to Both, for the relationship Listings - Rating Group Formatting. Then you will get gradient colors

[@naomiwangu9044]

thank you, was stuck on this step @@miljenko-vv3vb

[@ElevateTheFacts]

Hello brother, need some help of yours...i have created that rating formatting table. But once i am using that in funnel chart for conditional formatting it is just coming as red funnels not becoming gradient. I have also made a relationship with listing table. Thank you for this amazing project, really appreciated.

[@PowerBIBro]

Happy to help and thanks for the question! For the relationship created in the model, is the directionality set to 'both' and not 'single'?

[@maitrph]

Hello Robert, I've finished all the parts except for the Azure map. Couldn't enable Azure map in PBI Desktop - free version whereas other maps work fine. The notification was: "To display Azure maps visuals, sign in". It requires a work or school account to sign in which I don't have (only have a personal one). Not sure if creating a free Microsoft Fabric account would fix the issue. Do you know the solution for it or perhaps the only way to fix it is by upgrading to a paid account? Much appreciated.

[@PowerBIBro]

Excited that you've completed the majority of the video and thank you for sharing! Great point about the Azure map and the sign-in step. If you do not have a work account there most likely is not a way around this to my knowledge. Please let me if you find a route to resolve it!

[@mnedix]

Great project end-to-end but even if I did everything as in the video, I still didn't get the column chart correct. Unfiltered it look as it should but once I click a rating or a country then the chart is filtered "in place" as in showing also the Genre columns which have no values for that respective country.

[@PowerBIBro]

Thanks for reaching out! It sounds like it may be a relationship issue in the data model. If you open your data model and review the relationships, are the bi-directional or single? You can open up the pbix file in the git to review the model used in the tutorial. If you try double clicking your relationship lines, and setting them to bi-directional (both), does that fix your issue?

[@mnedix]

@@PowerBIBroThe settings are exactly as in your file (relationship bi-directional). Maybe I messed up a step in execution.

[@tomash9785]

thanks really nice work. trying to replicate the work I have an issue with reference label. When I add glow or shadow to kpi card, reference label rectangle is pushed left relative to callout rectangle. The same thing is with a pbix file which I donwload from github upon opening the file. So just putting it here if someone has the same issue

[@PowerBIBro]

Hey I have a fix! There is a strange bug in the Dec PBI release which causes a formatting issue with the glow/shadow of the KPI Card. If you uninstall Dec and install Nov (found below), it will be a temporary fix for the issue. Hopefully Microsoft will release and updated bug fix soon. You can down the historical releases here. At the bottom of the November section you can see the download option. Let me know if this helps! learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-desktop

[@ranitbhattacharyya3800]

Not getting the Azure Maps

[@PowerBIBro]

If you download the pbix file does it work for you?

[@RG-kk5oo]

wow! ty

[@PowerBIBro]

Thank you!!

[@diya_dr5]

27:00

[@PowerBIBro]

Haha! Thank you for your support!!

[@balaroxx2700]

55:41 i cant make many to one relation ship for listings to z rating group formating it is only allowed for many to many is that a problem?

[@PowerBIBro]

Hi and thanks for your question! You are correct that you should avoid many to many relationships. To help, if you download the file from GitHub do you get the same issues?

[@balaroxx2700]

I cleared it thanks for the reply ❤❤❤ expecting many impressive project like this to attract the recruiters🎉

[@ranitbhattacharyya3800]

Couldn’t able to upload Netflix Symbol

[@PowerBIBro]

Strange what error did you receive?

[@newincomprendidos]

Im trying to figure why I the color palette doesnt put in the the fill color. I made the relation with the tables, check the types of both columns of Rating Group but when I try to make the conditional with the Field Value Format Style, all the rating group field stick to the first color. What im doing wrong? - The relation is okey - The types of the columns are the same - The symbol "#" is in all the fields of the column fill colors

[@PowerBIBro]

Thanks for the question! If you download the PBI file uploaded to GitHub, and try to set it up on that file, does it work for you?

[@newincomprendidos]

@@PowerBIBro Thanks for your reply. I discover what I was doing wrong! Im learning so fast Power BI thanks to you

[@suyashlade25]

@@newincomprendidos what was your mistake bro?

[@juiroy8924]

hello, hope all is good, could you please make a video on how to upload an interactive dashboard on Novypro, that is updated in their version, as a showcase portfolio we need an interactive dashboard, thank you..

[@PowerBIBro]

Hello and thanks for the question! I think this is a great idea and I will work on it.

[@huyuc6614]

Your dashboard is no nice as well as your tutoria. Do you have another full 2 hours like this

[@PowerBIBro]

Thank you so much! This is my only full 2 hour video but I I have many other videos detailing PBI features in depth!

[@ElieGhossein-w3s]

Just amazing and great job! But please stop making noises with your MOUTH!! It is so disturbing and disgusting.

[@PowerBIBro]

Thanks for your support and feedback, I’ll take note and appreciate your input!

[@rohitguleria100]

are you younger brother of bear Grylls?

[@PowerBIBro]

Hahaha! Love it 🥾🥾🌳🌳🦌