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

Подписаться 2,6 млн

Просмотров 90 тыс.

50% 1

👉 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

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 124

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

@StaticBlaster Год назад

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

@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

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

@snakedragon11 Год назад

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

@LeilaGharani Год назад

Thank you!

@kodwomensah4649 Год назад

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

@janetbutts7132 2 месяца назад

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

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

@user-nz1yh2jh9z 8 месяцев назад

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.

@HusseinKorish Год назад

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

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

@sreekalasathyanathan3007 Год назад

Thanks Leila! Excellent video as always!

@webersworld7723 9 месяцев назад

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.

@Bhavik_Khatri Год назад

Thank you for the update

@aleemaza Год назад

Thanks for the updating us, its really amazing 😍

@sylvainricher4926 4 месяца назад

these options are very useful. Thks

@fatemehmahjouyan6389 10 месяцев назад

Great. Thanks for updating

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

@gospelmoto2833 Год назад

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

@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

@brianbaheramouzegarletsbui6533 Месяц назад

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

@LeilaGharani Месяц назад

Thank you! 😃

@evanyeung3801 Год назад

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

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

@j-town4408 Месяц назад

Thank you!

@aliyusulaiman9642 Год назад

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

@pieterwdevilliers Год назад

Appreciated Leila! Thanks again.

@pravallikanaidu3319 7 месяцев назад

Thank you very much 😊

@dheerajvarapana1124 Год назад

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

@LeilaGharani Год назад

Happy to hear that!

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

@prathameshbile5865 Год назад

Thank You Ma'am!

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

@chrism9037 Год назад

Awesome Leila, thanks!

@LeilaGharani Год назад

Thanks, Chris!

@user-ri7sw2wt6f Год назад

I like the new feature a lot.

@alirezamogharabi8733 Год назад

Thank you Leila

@LeilaGharani Год назад

My pleasure, Alireza!

@mahendragupta2512 Год назад

Worth session !!

@francismastro Год назад

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

@kannanmdu Год назад

Thank you so much leila

@LeilaGharani Год назад

You're welcome 😊

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

@syedhannan546 Год назад

Nice 👍

@theenlightened1s Год назад

Love it! MS is innovating x 10 this year

@LeilaGharani Год назад

Sure is!

@satish23kumar Год назад

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

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

@omarnader776 Год назад

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

@Fatababei Год назад

@aleksandaratanasov105l Год назад

thanks god they didi it finally

@ahmedtareq5342 Год назад

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

@CityTunes Год назад

Molto bene!

@rokiczaaa 8 месяцев назад

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

@EdHigh Год назад

Nice

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

@mohamedabdulatty7997 Год назад

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

@ilonabulbakh6933 2 месяца назад

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

@CideeTV Год назад

nice..nice

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

@richardhay645 7 месяцев назад

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

@LeilaGharani 7 месяцев назад

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

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

@aicnedvasquez Год назад

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

@secrettips4242 Год назад

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

@k.sweety2868 Год назад

Hey you give the new information to me thanks

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

@TomClarkSouthLondon Год назад

*Leila!* 🤗

@sebastianw8952 Год назад

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

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

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

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

@Excel_explorer Год назад

👏🏻👏🏻👏🏻

@guiller.7103 Год назад

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

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

@masoudmadani9620 2 месяца назад

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.

@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

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

@Wzxxx Год назад

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

@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

@randyvelasco5079 Год назад

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

@linamustafa6152 Год назад

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

@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

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

@jugoanata6717 Год назад

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

@Ganja1974 Год назад

1st integration of Power BI into Excel environment.

@KirozZzZ55 Год назад

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

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

@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

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