How To Create these useful Power Bi Visuals that Excel Lacks

[@LeilaGharani]

Ready to learn Power BI? Start creating reports today! 👉 link.xelplus.com/yt-c-visuals-powerbi-starter It’s simple, fast, and perfect for beginners-no jargon, just results!

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

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

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

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

[@amrbehzad]

Thanks!

[@LeilaGharani]

Thank you!

[@konigkakfas3392]

Danke!

[@LeilaGharani]

Thank you!

[@cvijodubocanin1407]

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

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

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

[@bggg1]

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

[@christianwibowo6420]

Still The greatest teacher on KZbin

[@philippepierre2954]

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

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

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

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

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

[@silvestrecamposano6317]

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

[@chazzcapone.]

@leilagharani #leilagharani The stats you cited in the beginning of your video 0:07 would you please note your sources of information for us?

[@LeilaGharani]

Hi - the source is in the video right below the stats.

[@KonstantinosVamvakousis]

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

[@humansizedaperture]

Gold standard presentation!

[@diegobevilacqua4391]

Fantastic! The last visual for me is more interesting!

[@allaboutpakturkeydramas7063]

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

[@sakibahmed1815]

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

[@lailapsiqueira]

About the composition three, is there a way to see the values as %%? Thanks for de video!

[@sonia25266]

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

[@JahongirJalilov-c8k]

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

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

[@tomr9969]

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

[@chh8860]

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

[@LeilaGharani]

Thanks again, Chris!

[@muhammedabdulkareem7111]

Thank you for dropping this

[@taizoondean689]

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

[@Rice0987]

2:58 I like how add runs away from mouse cursor. And your hair today are absolutely stunnig!🤩

[@LeilaGharani]

Haha, thanks for noticing. My video editor will get a kick out of this 🕺 #hairbydyson 😊🙏

[@Rice0987]

@@LeilaGharani Why kick out? Give him a premium ! Also give one to Dyson. He made brilliant outlook of our beautiful teacher!☺

[@aleawolf9848]

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

[@mahaboobkhan7439]

Great and very useful presentation. Thank you for this.

[@aydoganilhan1]

Great to know all these, thanks from the heart!

[@fluffybasket5674]

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

[@ExcelTutorials1]

I love the stats at the beginning

[@alexanderlawrence7707]

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

[@LeilaGharani]

Most welcome!

[@brianbaheramouzegarletsbui6533]

Great work, again, Leila. Thank you!

[@SyedMuzammilMahasanShahi]

Thanks for sharing this wonderful video.

[@sheebanishat]

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

[@LeilaGharani]

Great to hear!

[@GerhardHolzer911]

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

[@LeilaGharani]

Bitteschön 😊

[@reenamohanta2994]

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

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

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

[@AP-eb8hd]

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

[@LeilaGharani]

My pleasure 😊

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

[@sass520]

Excel Is Excel and Power Bi is POWER BI 😇😇

[@VeganSmasher]

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

[@extraktAI]

The graphs are amazing, the biggest trouble I have is organizing and preparing the data for analysis

[@nielsduursma1684]

Which measure have you added to profit, to use it in the decomposition tree?

[@ExcelTutorials1]

Thanks for the great tips!!!!

[@Cheechorito]

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

[@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 :)

[@pondyanand]

Great content as always ! Thanks.

[@modalities]

A highly valuable knowledge share. Thank you!

[@nanettereyes]

You're simply amazing!

[@carlaniesen4912]

Excellent as usual! Thank you.

[@yourtuber2000]

Nice!!! must try! thanks Leila

[@makarand1985]

Great Video Leila !!!

[@lucasguidi]

Can I edit the "play axis"? The idea is great, but it's too big in the top right corner.

[@RZing]

Will the Power BI on Udemy soon? Thank you!

[@Bhavik_Khatri]

Excellent tutorial.

[@jasonipfatsiong2062]

Very impressive thank you😊

[@robsonmachado2703]

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

[@muralimohan71]

Thank you 😊

[@chrism9037]

Excellent as always, thanks Leila!!

[@LeilaGharani]

Thanks again, Chris!

[@thoughtfuldog5424]

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

[@raymondzhang9355]

Could you send the coupon for BI course

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

[@pedrofontes22182]

Hi Leila! I was using the decomposition tree as a complement to Drill-Through capability. But what I notice is that when I go back to the initial page, change selection and go to the drill-through again, the "scenario" in the drill-through headers continues to appear the same even if the figures in the tree are ok. This happens up until I start clicking through the decomposition tree and then the scenario in the header of the visualisation gets updated... any idea why? Thanks!

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

[@think3technology640]

Last one is more informative visual!!!

[@Khan-mc3gi]

Wow great job👍

[@learnexcelwitht]

Absolutely fantastic

[@minathanh7072]

Hi Leila, how can your scatter chart/marker showed beautiful colors like that? Mine was by default and I couldn't change it (Markers > Color > Show all). Please help if you have some insights how to fix it! Thank you.

[@yulinliu850]

2M subscribes soon 👍

[@pthapa55]

Awesome tips, thank you!

[@MarinaV-P]

Thank you sooo much!!!

[@nigelcole225]

Superb - thank you

[@giorgidvali951159]

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

[@LeilaGharani]

You are most welcome, Giorgi!

[@geethagowda2222]

Great Work ! when i tried to replicate the same, i dont see some features currently avaialble any alternate suggestions please

[@wodibalanakassoukpala2472]

Got more information about the use of Decomposition tree. Thanks

[@sayedhofiani8041]

awesome content leila

[@hemvaidya]

blessed to learn

[@MrLausell]

Excellent!

[@FaysalEasyExcel]

wonderful. this is amazing.

[@albert4491]

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

[@Mr.Nichols]

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

[@rahamatmadarangi]

Is there a way where we can add the data for pervious year and the current year next to that and also need to see the month header to me static

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

[@fredericktruter5292]

I have completed your free Power BI training a gaint leap for all of us. I know this is not your problem, exchange rate, the cost in Big Mac's is 30 for a US citizen for us in Africa 77.5 Big Mac's.

[@abhayvinayak5140]

Hi leila excellent video however it throws a message for infographic "Upload_Svg image instead of shape" when try to upload svg image

[@MrCutlash]

Appreciate the video. That ribbon chart is difficult to process. I'd rather use a bar chart.

[@LeilaGharani]

👍

[@mohitupadhayay1439]

Would love to see your DAX playlist on power BI

[@cerealport2726]

Maybe it is because I am not a frequent user, but Power BI frustrates me a lot compared to Excel, but some of its visualisation tools are great, and it's nice to be able to easily use Python to access proprietary databases without having to export and import data manually.

[@Ronnet]

The way I see it Excel let's you do whatever you want but isn't very "smart" about it. So you need to manually connect all the pieces of the puzzle. The complexer the puzzle you make, the more lose ends you have to deal with (and it can end being a lot more work then you imaged). PowerBI on the other hand limits you in what you can do but this is to ensure it continues to understand your logic. I find that once I get going it is so much easier to finish a project and typically it just works without any undesired consequences no matter the complexity. So PowerBI is frustrating in the beginning but in the long run it just works.

[@Otis151]

I'm really interested in using a Sankey Diagram, but i dont understand how to do multiple layers.

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

[@KimHongTan]

Hi Leila, can you share where can I download the Unisex SVG file ? It doesn’t seem working from my end.