Easiest Way to Edit Visuals in Power BI - Watch before using the new features (Includes hidden tips)

👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-AI-powe...
Editing visuals and charts in Power BI just became more Excel-like. So if you're familiar with formatting charts in Excel, you will love this Power BI update!
Microsoft introduced a new way to build and format visuals directly ON the visual. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text. Just like you're used to in Excel charts.
You can now easily format your bar, column and line charts directly on the canvas. There is an object edit mode. You don't have to keep going to the side panel to make your updates. Double click on your visual to get the blue border and edit the chart as you need. Check out the video and time stamps for more detail.
After-all most people who open Microsoft Power BI for the first time are overwhelmed. They struggle to navigate around the many panes to perform even simple actions. This update will change that.
Note: This feature for contextual on-object interaction with Power BI visuals is currently in preview. You need to turn it on manually in the Options - Preview features.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 New Power BI On Object User Interface
00:14 How to Turn On-Object Interaction On
00:32 What's Changed in Power BI
01:19 Contextual Options to Build Visuals
02:49 New Formatting Options
03:30 How to Add a Subtitle and Divider to Your Visual
03:57 Pane Switcher and How to Bring Back Closed Panes
04:27 How to Open Different Panes Side by Side
04:52 Turning On the Format Mode for Visuals
06:13 Canvas Settings
06:28 Wrap Up
🎬 LINKS to related videos:
- How to Use Microsoft Power BI: • Power BI Tutorial For ...
- How To Create these Useful Power Bi Visuals that Excel Lacks: • How To Create these us...
➡️ 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

[@chh8860]

I would have found these features on my own ... NEVER! Once again an information-rich video from Leila ... that I will have to watch several times to fully absorb ... and then again. Thank you ... thank you ... thank you ... 😍😍😍

[@LeilaGharani]

You are so welcome, Chris! Thanks for watching!

[@b0159673]

I understand that this is useful for people transitioning from Excel. BUT I really hope that they keep it as an option and don't end up forcing it upon us. For seasoned PBI users, it's a lot more effort and clicking.

[@Scott-lc5kh]

They’ll force it for sure. Just look at the new visualisations pane (which I guess is gone with this new update 🤷‍♂️). Most users hated the changes. They went ahead and forced it on us anyway. I swear no one working on the powerbi UI at MS uses the product. If they did, they wouldn’t have made many of the decisions they have recently.

[@Wzxxx]

I really hope there would be an option to keep the old setup. The best would be to have old setup but with horizontal pane options

[@StaticBlaster]

I swear you're the best teacher ever, not to mention extremely beautiful.

[@mazchen]

Yours was not the first channel showing the new options. But your video was so far the best one in terms of explaining the features, especially the not so obvious ones in a crisp way, without getting lost in details. Btw, I like the new format options.

[@user-nz1yh2jh9z]

I am pretty new to Power BI. The company pushed out the Power BI update without telling us what the changes were. I thought I was losing my mind. Though I figured out some of it, this video really sorted everything out. Sane again. Thank you.

[@webersworld7723]

It takes a little bit to get used to, but after using for a couple months, I really do think it’s worth it. If you’re designing a whole page, maybe not. But when you just want to change some formatting quickly, I love it. I didn’t know what the blue boundary was doing so I’m happy I found this video.

[@janetbutts7132]

I'm a novice user, and this is so helpful. Thank you!!!!

[@brianbaheramouzegarletsbui6533]

Best in class. Another great video. Thanks, Leila.

[@LeilaGharani]

Thank you! 😃

[@kodwomensah4649]

Great feature especially for those transitioning from Excel. Thanks Leila for the great delivery.

[@snakedragon11]

These features look great and give it a modern feel. Big fan by the way 👍

[@LeilaGharani]

Thank you!

[@HusseinKorish]

Perfect Explanation for the new features ..... thanks Leila

[@vijayarjunwadkar]

Thank you Leila! I was about to explore this new fearure on my own and chanced upon your video, so it became more clear and understandable. Always love your enthusiasm in teaching and of course the way you present and explain! 🙂

[@LeilaGharani]

Thank you Vijay!

[@ilfacone]

I'm sure there'd be some temporary discomfort when moving over to this view, but maybe in the long run - its a beneficial upgrade to utilise. I've found that the formatting pain was difficult to understand when I first started using power bi - but now it's intuitive to me - purely because I use it every day. I'm on some reddit groups for power bi / data science - and formatting improvement is a regularly discussed feature. Maybe they're listening to their users more now. thanks for making this video - I'll try out this new view. :)

[@surjaa.c]

Thanks for the great introduction to Power BI's new features, Leila! As someone who is more comfortable creating and customising charts in Excel, these new features definitely make it easier for me to use Power BI for data visualisation. Tbh, I had always been a little intimidated by that Formatting pane (shhh don't tell anyone, it's a secret!) 😂

[@alperkins66]

Again, you absolutely nail it with superb training. Keep up the excellent videos. Such a big help for us noobies.

[@joanneosborne2428]

Excellent tutorial. Thank you, Leila.

[@barttitulaerexcelbart9400]

Thanks Leila. Excel and Power BI a good mariage.... The way you present here is just like I am listening to a new chapter of your excellent course "up and running with Power BI".

[@evanyeung3801]

This is a game changer, definitely make Power BI visuals Way more easier to edit and play with!

[@sreekalasathyanathan3007]

Thanks Leila! Excellent video as always!

[@sylvainricher4926]

these options are very useful. Thks

[@aleemaza]

Thanks for the updating us, its really amazing 😍

[@Bhavik_Khatri]

Thank you for the update

[@fatemehmahjouyan6389]

Great. Thanks for updating

[@gospelmoto2833]

Thanks again...Ms.Leila. u r awesome!

[@aliyusulaiman9642]

You are my favorite KZbinr, I really learned a lot from you. how I wish you will do a tutorial on programming or database (Access)

[@gennarocimmino]

Thank you and congratulations for the excellent exposition. I like this new feature because it gives users the choice of retaining an Excel-like environment or keeping the original PBI layout. Freedom is always better than constraint ... :)

[@kuuuyajim]

So that's what the recent update is about. 🤔 I'm already used to the old format but I'm going to try this update. Thank you, Leila!

[@pieterwdevilliers]

Appreciated Leila! Thanks again.

[@pravallikanaidu3319]

Thank you very much 😊

[@j-town4408]

Thank you!

[@sapocyte]

Hi Leila! Thanks for everything you do. I learn a lot from your videos. I wanted to ask you about how could I have interactive charts and tables in powerpoint (presentation mode). I explored Power BI a little, but I got confused by the different products there are.Thanks again!

[@francismastro]

I want to thank you for this... I was looking where is the new location for the Drillthrough... Thank you!!! 😊

[@patrickkinbonso1809]

Thanks Leila. When I created cluster column charts in Excel, I enjoyed what you show me previously re: highlighting the top 3 highest elements by having extra preparation columns. Can we still do it with Power BI please?

[@dheerajvarapana1124]

You are the best. This is very useful & I love it.

[@LeilaGharani]

Happy to hear that!

[@prathameshbile5865]

Thank You Ma'am!

[@omarnader776]

Excellent tutorial. one question I have, how to import data from qia extension file to excel using power query.

[@user-ri7sw2wt6f]

I like the new feature a lot.

[@chrism9037]

Awesome Leila, thanks!

[@LeilaGharani]

Thanks, Chris!

[@alirezamogharabi8733]

Thank you Leila

[@LeilaGharani]

My pleasure, Alireza!

[@satish23kumar]

Nice. Way to go. But ideal shall be when the options come in dedicated ribbon, grouped by relevance

[@kannanmdu]

Thank you so much leila

[@LeilaGharani]

You're welcome 😊

[@theenlightened1s]

Love it! MS is innovating x 10 this year

[@LeilaGharani]

Sure is!

[@saburudeenmct5518]

Formatting is the only area, i always think Excel is better than Power BI, cos we can easily add/remove any chart elements and add/remove formatting to it. Now, finally Power BI is updated. I love this update.

[@ilonabulbakh6933]

Generally speaking the new interface is much better, less clunky 'typical old microsoft' one but thanks Leila for explaining the difference before I started with the new one otherwise I would struggle with the unknown updates

[@SaskiaJacobsen_Toels-PC]

I prefer this other approach, but I am an Excel user. And I think a lot of Power BI users also use Excel (and other Office apps). What I like most is the option to use the right mouse button in more situations. In my Excel courses (but also other programs) I always tell that the right mouse button is your BFF (Best Friend Forever). Why? Because with every update things CAN be replaced and then you have to search. But most of the times the things you need most are under that mousebutton!

[@LeilaGharani]

Thanks, Saskia!

[@leme4089]

Dear Leila, could you help me please? We have a BI table at work, is it possible to somehow add columns where we could add notes to a given row, and they would not disappear when the table is updated? Thanks in advance for any help. You are amazing 💗

[@ahmedtareq5342]

Nice, would you please do a video covering on how to use Deneb with vega lite or vega to design Gantt chart

[@syedhannan546]

Nice 👍

[@mohamedabdulatty7997]

Great How can I change calculation from sum of sales to average of sales or max and so on...

[@mahendragupta2512]

Worth session !!

[@judyl.7811]

0:05 so much office-like is power BI 0:15 tips i came across. 2:10 turn it off by options. 2:55 this is contextual 5:00 right mouse click to the Format. 5:55 when you in format mode, the default behavior of power BI is deactivated. 6:05 on-object formatting: bar, column, line, area, combo, scatter chart. 6:15 Canvas options: select Format Canvas 6:25 drill-through settings under Page information

[@rokiczaaa]

I missed these options in PBI. It may will be easier for me to like PBI :D

[@aicnedvasquez]

Hello Leila! Does PBI for Desktop get data from M365 Lists?

[@Fatababei]

TY

[@aleksandaratanasov105l]

thanks god they didi it finally

[@santoshadhikari9933]

Just like we can make Python visuals, can we write a Python code to loop through slicers in the report and export the PDF of the selected slicer containing all relevant data of that selected and do it in a batch like creating 100 pdf at once?

[@secrettips4242]

Is there any Excel add-on that can create actionable insights automatically without me creating pivots and explore?

[@CityTunes]

Molto bene!

[@sebastianw8952]

I am still waiting for transparancy in linechart specifically on secondary axis. Anyone knows where to find it?

[@richardhay645]

When I saw you had released a new video I assumed it was about the 3 new Eta-Lambda functions!!?!

[@LeilaGharani]

I still don’t have those. Can‘t wait…

[@k.sweety2868]

Hey you give the new information to me thanks

[@EdHigh]

Nice

[@LeilaGharani]

Hope you enjoyed the updates. If you'd like to learn Power BI from scratch, join our Fast Track to Power BI course: www.xelplus.com/course/fast-track-to-power-bi/

[@barttitulaerexcelbart9400]

Sorry, I meant the course of Xelplus...excellent course!!

[@aliyusulaiman9642]

Yes, of course

[@CideeMedia]

nice..nice

[@serawitbogale3144]

Dear Laila Ghurani, Your videos are valuable thank you for your rentless efforts. I am currently working in project where most of the issues are time related , measured in hours and minutes, as you know Power Bi is not customed to add or subtract hours. Please if you share a video for simple addition and subtraction of hours data in Power Bi , I would be thankful. The machinery rental rates and the worked Gower for people are the measure for payments and related computations of efficiency , Please I really appreciate if you do a video on that.

[@guiller.7103]

How to fix photo legacy using cmd it won't let me add files from pc to edit videos thanks

[@miamimc711]

Leila, when you released PowerBi course, you offered a promo code. Do you plan to offer it again?

[@LeilaGharani]

No sorry, that was for the launch only.

[@miamimc711]

I signed up for the newbies one hour power bi mini course, URL was in the power slicer video from a couple of months ago. Luckily, I was able to sign up for the full PowerBI course and get the $60 discount- thank you.

[@TomClarkSouthLondon]

*Leila!* 🤗

[@masoudmadani9620]

Hi Leila I have a common problem with Power BI. It's really making me frustrated because everytime I use that, I don't know what would be the result. Eveyrtime I use tooltip option for a huge data (for example candlestick of an stock for more than a month) I will see that the tooltip has a scrollbar at the bottom. And you definitely know it is useless! Because you can't hover the mouse on that. So I am not able to see the whole data. Is there a way to show all the data in the chart without dealing with scrollbar? (Like Excel Charts that doesn't have scrollbar) Looking forward to get help. Thanks a lot.

[@Wzxxx]

Nice but it is bugged. I see some option through the code line

[@kahhengyeong7947]

Ok, it's one less pane on the side, but always a bit of pain trying to get used to the ever changing interface...

[@shivanandkmt]

Hi I am looking for a function in google sheet, can you help me. Data details Two columns ( A, B) Eg A B Car 23 March 26 Apple 25 ... Long table ------ Filter : ar ( part of string) Answer A B Car 23 March 28 How to do above in google sheet?

[@shafa7668]

I was really passed off when I turned on this preview feature. Now I can't go back to previous layout even if I have turned off this preview feature. It will take a while to get used to it.

[@zuljiwani174]

Hi Laila: Will you be updating your Power BI course to include these new features?

[@muhammadharisfarani8316]

@LeilaGharani I have a problem with excel. how can we count or sum a number lies somewhere in text. for example: Ghty 5jhu Ghbj 6jkn Ghbd 4hjk and I want to count or sum only numbers from these texts. kindly guide. thank you a lot... I am waiting! 😁

[@JBB685]

You said “somewhere” in the text. Is it always four letters, your number, then 3 more letters? Or does that change

[@b0159673]

Learn about using power query. It will make this sort of thing a doddle! Leila had lots of videos on it.

[@muhammadharisfarani8316]

@@JBB685 the examples I've given are just random. the text is like: anything 3kg some food 2kg sugar 5kg the list is like this... and I want to count all these, like these are 3 items in total. and also want to sum all of them, like these are 10kg in total... note: the text of each row lies in a single box of excel sheet...

[@aicnedvasquez]

Hello MHF! If "kg" were a constant, I would FIND "kg", then - 1. With this result, use EXTRACT or MED. Finally, VALUE.NUMBER. VALUE.NUMBER(MED(FIND())) ☝That formula in a Column, then SUM. Hope it helps.

[@muhammadharisfarani8316]

@@aicnedvasquez thanks a lot...

[@linamustafa6152]

How do I change my theme from Power BI to black i tried everything

[@randyvelasco5079]

April 2023 update is already out... more features to discover.

[@Excel_explorer]

👏🏻👏🏻👏🏻

[@Ganja1974]

1st integration of Power BI into Excel environment.

[@brandenm.1537]

I was using the changes for about 2 days until I ran into an issue with moving fields in a table, and they wouldn't move like they used to. That was aggravating. I then wanted to drag some custom date fields in the heirachy around, and it didn't let me. I turned it off. I like the old much better

[@jugoanata6717]

Wha user bi need is full screen mode, because not everbody can buy pro version

[@sallysally58]

Accounting professionals must have expertise of EXCEL, POWER BI, ERP to be a successful CFO. Which other skills they should have to Digitally transform any enterprise independently?

[@Xrusader]

I tried the new feature. Seems like a lot more clicking to accomplish the same thing. Turned off until Microsoft forces me to use it.

[@RaisingTheAnte]

This looks like a headache 😭 I fully agree with your comment

[@martinpaulbannister1745]

Agree. I turned it off after 10 minutes. Understand some users will like this new feature, they may even find it easier. It’s not for me

[@Scott-lc5kh]

Seems like MS has been deliberately trying to make it harder to use PowerBI the last year or so, all under the guise of “improvements for the lay-men”. PowerBI is a pro-user product. They need to stop trying to dumb it down.

[@dedelp2]

I hope they don't force us to use this fake improvement in next releases. Although this overview video is great the new features NOT. I hate it ALL

[@KirozZzZ55]

They need to find a way to facilitate editing the interaction between items (cards charts,,,) in the same page

[@shubhammittal6509]

Trying to getting used to new format pane interaction. Ask MS to retain this way for atleast an year or so.😅

[@defeatedgamerz3838]

Sssssoooo ssssssweett ssssssound

[@kajola]

Habit is great, tried the preview, went crazy, turned it off again

[@leopuerto8039]

Thanks for the video. I hope this visualization of the desktop would be optional. Is honestly so confusing and I don’t think it resembles excel at all. I am not even sure why they spent so much time in changing the visualization panel. It was intuitive before now you have to search against all the other tabs to find it. Not a big fan.

[@Wzxxx]

And still no dark mode in 2023 where it is a standard in every all.

[@mikedonaldson8898]

I have to admit, I do not like the new menu layout. I find myself looking and clicking through so many menus looking for something I can't find.

[@anteep4900]

big n0pe from me

[@OutofBal]

Yuck!

[@taimurSM]

Garbage update by Microsoft. Newbie friendly, slow and anti-power users.

[@dedelp2]

I hope they don't force us to use this fake improvement in next releases. Although this overview video is great the new features NOT. I hate it ALL

[@boobacly9103]

If only they could invent something that will allows me to transfer all of @LeilaGharani's knowledge into my brain

[@LeilaGharani]

😆