How To Create these useful Power Bi Visuals that Excel Lacks

👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-visuals...
Dive into the world of advanced data visualization with Power BI! Our video tutorial showcases some of the most impactful visuals in Power BI, turning complex data into insightful, actionable information. Perfect for business analysts, data scientists, and anyone looking to elevate their report design skills.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 link.xelplus.com/yt-d-visuals...
Highlights of This Tutorial:
▪️ Ribbon Chart: Discover how to track rank changes and data over time.
▪️ Decomposition Tree: Explore this AI-powered visual for multi-dimensional analysis.
▪️ Scatter Chart with Play Axis: Learn how to analyze changes over time with interactive scatter plots.
▪️ Infographics & Custom Visuals: Get creative with custom shapes and dynamic visuals in your reports.
Here is a list of my favorite Microsoft Power BI visuals. I'll show you how you can turn data into actionable decisions. You'll learn about 4 powerful visuals in Microsoft Power BI. We'll start with the ribbon chart to easily identify rank changes over time. Next is the Power BI decomposition tree which lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It also has an Artificial Intelligence (AI) feature that can find insights for you. Then we'll take a look at the scatter chart in Power BI which comes with a special twist. It has a play button so you can visualize the change in the bubbles over time. And finally, I'll show you how easy it is to use infographics in Power BI to get your message across. Neither of these charts is easy to setup in Excel.
00:00 Powerful Data Visualization in Power BI
00:55 Ribbon Chart
03:17 Decomposition Tree
05:49 Scatter Chart with Play Axis
07:08 Infographics
10:17 Wrap Up
🎬 LINKS to related videos:
- How to Use Microsoft Power BI: • Power BI Tutorial For ...
- 10 Power BI Tips for Better Dashboards: • 10 Power BI Tips for B...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi

[@LeilaGharani]

If you found this video helpful, you're going to LOVE my FREE Power BI QuickStart course 👉 link.xelplus.com/yt-c-beginner-powerbi-freecourse It's designed to get you results FAST, without the techy jargon.

[@stevenisaakcoronadohs4256]

do you know of a free course for teachers? My school is moving towards mounting these TVs that are interactive. I have been using an iPevo. FYI, I teach mathematics. Thank you steve

[@salembalkhair9656]

When can we enroll for the full course

[@atabak1972]

The quick chart we part in SharePoint is poor

[@donnataylor8715]

Thanks Leila, I am teaching Excel and Power BI to workers in different businesses as part of a continuing ed program. I always plug your channel with "By the way, if you want more check out this channel". Keep up the great work.

[@LeilaGharani]

Thank you for your support, Donna! I hope your students will find the videos helpful.

[@ryds2722]

Definitely suggest adding Knaflic’s book, ‘Story Telling with Data’, to your resources list. The book is detailed, simple, and easy to digest - just like my ideal visuals 😊

[@cvijodubocanin1407]

This Scatterer over time is a real deal, big boooom. Great video Leila as always, thanks and keep it up.

[@TheSweetMaze]

Thank you for the Power BI videos! You teach very well and they are easy to understand. You speak well and clearly too, which helps a lot when I'm trying to follow along with you. Please continue to share more Power BI tutorial! More power! ❤️

[@LeilaGharani]

Glad you like them!

[@christianwibowo6420]

Still The greatest teacher on KZbin

[@sonia25266]

This is so informative. As always, you provide excellent content! Thanks for sharing!

[@carlaniesen4912]

Please more Power BI videos. The power of this tool is amazing. Do you have advice on how to create narrative stories? If you elongated a page I can see a great opportunity for infographics. 😊

[@Cheechorito]

very informational to see all these rarely used features being highlighted!

[@fluffybasket5674]

Super impressed with these visuals that I never dared trying out for my models. Thanks for sharing!

[@brianbaheramouzegarletsbui6533]

Great work, again, Leila. Thank you!

[@sass520]

Excel Is Excel and Power Bi is POWER BI 😇😇

[@carlaniesen4912]

Excellent as usual! Thank you.

[@vijayarjunwadkar]

Super video Leila! I am using Power BI, but got to know so much more about these visuals! And the way you explain is simply amazing! I am previewing your new Power BI course and already impressed! You are doing a great job, and I am buying this course for sure! 👍

[@LeilaGharani]

Yay, thank you Vijay. Looking forward to seeing you inside the course!

[@diegobevilacqua4391]

Fantastic! The last visual for me is more interesting!

[@martinsmednis5544]

Thanks a lot for educating us!🙂

[@silvestrecamposano6317]

Wow... this is what I have been waiting to learn.... Thank you very much again!...

[@robsonmachado2703]

This video is insane! 🤯 Too much Incredible insights. Thanks a lot! Best wishes from Brazil! 🙋🏻‍♂️🇧🇷

[@taizoondean689]

Thank you ma'am 🙏🙏 please keep posting videos of Power BI

[@samlimam2740]

Hi Leila, This is an amazing video. Thank you very much ! Would you mind please creating a video on how to build a risk matrix using Power BI ? This would be extremely helpful. I'm looking forward to watching your video on the risk matrix :) Many thanks.

[@pondyanand]

Great content as always ! Thanks.

[@user-io6qo8wq2h]

Hi Leila. Thank you so much I get much information about Power BI.

[@user-xh8cr9pk5g]

Excellent Videos. Very professional approach and cystal clear examples. Thanks for this Leila.

[@mail2mazhar]

Cool charts explained in short video !

[@muhammedabdulkareem7111]

Thank you for dropping this

[@modalities]

A highly valuable knowledge share. Thank you!

[@allaboutpakturkeydramas7063]

You are too good Leila,Keep it up!Please upload more Power BI videos.

[@SyedMuzammilMahasanShahi]

Thanks for sharing this wonderful video.

[@shadrackawunyo7786]

Hi Leila, I really enjoyed this video. I had a 2nd thought whether to enrol in the main course but the diverse visuals you showcased has changed my mind. I can't wait to enrol

[@LeilaGharani]

Yay, that's great to hear Shadrack! See you soon inside the course.

[@sheebanishat]

Thanks for the video. I’ve enrolled in your PowerBI course and I’m enjoying it.

[@LeilaGharani]

Great to hear!

[@andrewcharlesmoss]

I was thinking about this yesterday actually. Power BI does have some really cool visuals that would be very much welcomed in Excel. Let's hope the development team sees this!

[@LeilaGharani]

👍

[@swake1822]

@@LeilaGharani Not going to happen though is it, or else it will cut subscribership, there's loads of tools that could directly be added to Excel but not good business for MS when we pay monthly for Power Bi

[@alexgry4763]

@@swake1822 there are reasons not to use Excel for important business processes. I love Excel and I know how to handle it. But many people don't. And in bad hands Excel quickly becomes a mess. Also, many organizations who have moved to Office 365 have PBI already covered by their subscription already. They just don't bother using it, because Excel culture stands in their way

[@swake1822]

@@alexgry4763 Good call, I like people to use my reports, not mess about with them 👍

[@mahaboobkhan7439]

Great and very useful presentation. Thank you for this.

[@aleawolf9848]

Your Videos are very helpful! I’m a big fan

[@smbsid]

Wow, another great video! Thank you @Leila for making us discover all the "power" of Power BI 🙂. Btw, I'm at 47% of your free preview and I've learned a lot.

[@LeilaGharani]

Awesome! Thank you!

[@tomr9969]

This was great! Infographics are amazing! I am going to try it now!

[@aydoganilhan1]

Great to know all these, thanks from the heart!

[@MarinaV-P]

Thank you sooo much!!!

[@pthapa55]

Awesome tips, thank you!

[@mikemartin2694]

Nice job! One tip, in the Scatter chart, select a data point, then play. A line will display the change over time. Easier to understand.

[@LeilaGharani]

Cool, thanks!

[@ExcelTutorials1]

Thanks for the great tips!!!!

[@ExcelTutorials1]

I love the stats at the beginning

[@bayarri81]

Thank you so much. By the way, do you know how we can show all the months of the last year but only the months that we select of the current year in a line graphic?

[@skirolf]

Great video. I suggest you make a video of presenting. I have noticed 98% of all videos on KZbin the presenter use a lot of disturbing hand gestures. Why? News reporters keep their hands on the table, why? I saw a video of one person with a helmet camera driving a motorcycle and he started making gestures with both hands while driving. He almost lost control and had an accident! Always keep your hands on the handlebar while driving! You have a good clear voice and good speed in your talking on your videos, perfect.

[@chiwilanjabulosikwila3487]

Amazing...😀 The capability of Power BI is vast, so one needs to upscale their knowledge and know how to use the various visualization tools. Sure the upcoming course will do just that! Great video as always Leila.

[@LeilaGharani]

It really is a power tool. Hope to see you soon inside the course!

[@vernacularbarnarchitecture]

Gold standard presentation!

[@nigelcole225]

Superb - thank you

[@SetYourBarTo10]

I knew you could do a time element with Tableau’s scatter plots, but for some reason I didn’t think to check that PowerBI also had that same functionality. Thanks, that will be useful.

[@jasonipfatsiong2062]

Very impressive thank you😊

[@obwanakennedy840]

Nice!!! must try! thanks Leila

[@bggg1]

You are the reason of my promotion! I love you! ❤

[@VeganSmasher]

Fantastic video that was easy to follow and sparked a lot of interesting Power BI ideas I want to try. Thank you!

[@chrism9037]

Excellent as always, thanks Leila!!

[@LeilaGharani]

Thanks again, Chris!

[@AP-eb8hd]

This is actually next level stuff... Way too good.. Thanks Leila..

[@LeilaGharani]

My pleasure 😊

[@learnexcelwitht]

Absolutely fantastic

[@Bhavik_Khatri]

Excellent tutorial.

[@GerhardHolzer911]

As always - really helpful video with valuable hints ! It’s always a pleasure watching - vielen Dank ☺️

[@LeilaGharani]

Bitteschön 😊

[@davestewart1196]

Hi Leila, great content as always. Quick question question. I'm very knew to Power BI. Where did the data come from in this example? Was it an imported excel file?

[@wodibalanakassoukpala2472]

Got more information about the use of Decomposition tree. Thanks

[@nanettereyes]

You're simply amazing!

[@shandor2522]

I know a guy who knows a guy who counted the visualizers on the market-and there are about 70! They mostly imitate each other as their makers vie for a pice of the pie. This video shows a step in the right direction-which is to automate the creation of effective visuals, instead of forcing people to learn Python & other languages.

[@muralimohan71]

Thank you 😊

[@alexanderlawrence7707]

New tips to excel in Excel... thanks 👌🏼❤

[@LeilaGharani]

Most welcome!

[@pedrofontes22182]

Thanks for this video! Useful and inspiring as usual. Suggestion: another video specifically on the ribbon chart, how to enhance the input to be taken from the lighter areas (if we can add fields, etc... same way we do for the "Tootips") and if it's possible to have the total for each ribbon at the top. This visualization can be really informative so probably it's worth to have a dedicated tutorial to it... Thanks again! :)

[@ajibolamoromoke8640]

Thank you

[@thoughtfuldog5424]

Brilliant, thanks. Can you provide more videos on the visualisations in PowerBI

[@giorgidvali951159]

Always usefully and helpfully video from you, thank you very much

[@LeilaGharani]

You are most welcome, Giorgi!

[@reenamohanta2994]

I admire you a lot .... you teach us so many cool stuffs ...

[@prashantpotnis]

Nice and informative video, as always. In the decomposition tree, is there any way that I can see all branches of tree as one visual? I want to see all the tree and not only one branch.

[@chh8860]

OMG ... yet again (no surprise) another thought-provoking video ... a fast-flowing river of ideas ... 😍😍😍😍

[@LeilaGharani]

Thanks again, Chris!

[@Mr.Nichols]

That intro had me H Y P E. Let's GOOOO #DataFam📈📈

[@FaysalEasyExcel]

wonderful. this is amazing.

[@hemvaidya]

blessed to learn

[@birasafabrice]

this is so informative, thanks a lot!

[@LeilaGharani]

Glad you enjoyed it!

[@think3technology640]

Last one is more informative visual!!!

[@sayedhofiani8041]

awesome content leila

[@MrLausell]

Excellent!

[@AngelloSuarezLovera]

I really enjoyed this video, great job! Also I have a question..in the infographic part I noticed the shape resize after applying filters with the slicers, how can I fix the shape in order to do not resize it ?

[@fivetimesyo]

10:26: Leila: "It just takes two minutes." You underestimate my clumsy...

[@georgevpopescu2421]

Do you also show the raw data in another video? It would be good to catch a glimpse of source figures that generate these awesome visuals . Thanks

[@abdulsaidmkamara7305]

Lovely !! That Decomposition tree can be an extremely powerful tool for finance performance analysis and measurement in finance and management accounting spaces.

[@LeilaGharani]

Absolutely!

[@Khan-mc3gi]

Wow great job👍

[@flourishwithMJ]

thank you.

[@srininsmp]

Thank you really usefull

[@JoelHernandez-vs1kn]

Gracias

[@sakibahmed1815]

Would be helpful if you had given the excel file in the description box that you are using to create power bi charts .

[@KurtSelden]

Thanks!

[@LeilaGharani]

Thank you, Kurt!

[@JamesWileyCPA]

Hi Leila - Loving your Power BI training videos and Fast Track course !! One question about Visuals that I can't seem to figure out - Is there a way to set custom increments for the range of values displayed on the x-axis & y-axis ? For example - If a Clustered Column Chart defaults to increments of $5M on the y-axis - is there any way to change this to smaller increments ? Thanx and keep the great training videos coming !!

[@LeilaGharani]

Hi James. Currently in Power BI, you can just set the start and end / min and max. There is an (old) request with a lot of votes that's still pending ideas.fabric.microsoft.com/ideas/idea/?ideaid=8d290c47-1aba-4044-920c-ba0ae3981742 - The recent BI updates don't also seem to have anything added for this purpose... If we can think of any workarounds will let you know. By the way, it's best if you post future questions in the comment section of the course. This way we make sure we don't miss your comment. On KZbin sometimes they go under :)

[@hermanbroeckx8329]

Amazing Leila

[@Holy_Random]

Hi Leila. What’s the model of your laptop shown in the video? Would you recommend buying a new surface laptop 5 or is the 4th series more than enough for the analysis tasks you do.

[@mohitupadhayay1439]

Would love to see your DAX playlist on power BI

[@albert4491]

Hey, Leila! Waiting for the scripts course! Will this be made available on udemy? :)

[@vikaasb2016]

Super informative ❤!

[@LeilaGharani]

Glad you think so!

[@moderncollectionkalyan3280]

really very nice

[@philippepierre2954]

Hi Lela, @9:18, why did you choose 1 as the maximum value? Thank you

[@RZing]

Will the Power BI on Udemy soon? Thank you!

[@christinebodge7568]

Awesome

[@alfiedavid1135]

love it!

[@neemaz]

Leila - I always watch your videos and am subscribed. Can you please post a video about how Iranians in Iran can utilize VPNs? They require guidance and you are very precise and technical and can explain the process very clearly.

[@konigkakfas3392]

Danke!

[@LeilaGharani]

Thank you!

[@chandrakantgaddam3437]

God bless you......!!!!!!!🙌