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!!!

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

4 ай бұрын

That’s a great idea and thank you!!

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

5 ай бұрын

Thank you so much!!!

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

@PowerBIBro

4 ай бұрын

Thank you!

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

28 күн бұрын

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

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

2 ай бұрын

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.

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

3 ай бұрын

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!!

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

@PowerBIBro

2 ай бұрын

Thank you for your compliment!

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

6 ай бұрын

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!

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

@PowerBIBro

5 ай бұрын

Wow, thank you!

Thanks bro

@PowerBIBro

26 күн бұрын

Thank you for sharing and my pleasure!!!

@noxious8507

26 күн бұрын

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

@PowerBIBro

26 күн бұрын

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

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

@PowerBIBro

5 ай бұрын

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

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

@PowerBIBro

4 ай бұрын

Thank you!!!

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

@PowerBIBro

2 ай бұрын

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

Explanation was good, keep continuing making such videos.

@PowerBIBro

4 ай бұрын

Thank you so much, I will!!

Finished watching

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

2 ай бұрын

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!!

Great tutorial!

@PowerBIBro

Ай бұрын

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

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

@PowerBIBro

26 күн бұрын

Thanks for sharing!!!

Thank you, great job

@PowerBIBro

6 ай бұрын

Thank you too!

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

29 күн бұрын

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!

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

@PowerBIBro

6 ай бұрын

Thank you very much!!

Excellent demo❤👍

@PowerBIBro

6 ай бұрын

Thank you very much!!

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

2 ай бұрын

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

2 ай бұрын

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

2 ай бұрын

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

2 ай бұрын

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

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

@PowerBIBro

6 ай бұрын

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!

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

7 ай бұрын

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!!

Nice work!

@PowerBIBro

6 ай бұрын

Thank you!

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

28 күн бұрын

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

27 күн бұрын

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

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

5 ай бұрын

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

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

@PowerBIBro

6 ай бұрын

Thanks for watching!

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

2 ай бұрын

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

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

4 ай бұрын

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!

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

3 ай бұрын

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 )

wow! ty

@PowerBIBro

7 ай бұрын

Thank you!!

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

5 ай бұрын

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

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

6 ай бұрын

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

3 ай бұрын

@@PowerBIBro workEDDD...

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

@PowerBIBro

5 ай бұрын

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

5 ай бұрын

thanks @@PowerBIBro

@kenneth24castle

4 ай бұрын

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

@PowerBIBro

4 ай бұрын

Awesome!!

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

4 ай бұрын

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

4 ай бұрын

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

@PowerBIBro

4 ай бұрын

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

4 ай бұрын

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

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

4 ай бұрын

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

4 ай бұрын

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

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

6 ай бұрын

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

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

3 ай бұрын

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

Couldn’t able to upload Netflix Symbol

@PowerBIBro

5 ай бұрын

Strange what error did you receive?

Not getting the Azure Maps

@PowerBIBro

5 ай бұрын

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

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

4 ай бұрын

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

4 ай бұрын

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

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

@PowerBIBro

6 ай бұрын

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

6 ай бұрын

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

4 ай бұрын

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

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

26 күн бұрын

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

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

@PowerBIBro

6 ай бұрын

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

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

@PowerBIBro

5 ай бұрын

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

are you younger brother of bear Grylls?

@PowerBIBro

5 ай бұрын

Hahaha! Love it 🥾🥾🌳🌳🦌