Power BI got a MAJOR upgrade - This changes everything!

oh it's here yay the March version of power ba adds a really helpful feature for creating charts in this video let me show you what this feature is all about and how it can make you awesome with power ba let's go make sure that you have the March 2023 version of power bi to check this go to the helper button click on about and look for this word March 2023 or above then we need to go to file options and settings options preview features and enable the on object interaction feature this is the new feature that they have added in the March version it will require you to restart your power bi we now have a new way to work with visuals within power bi you would notice that in the home ribbon now they have put all the chart options right here rather than as a panel on the side not only this increases the screens screens you have for us to work with the visualizations that you are building but it also kind of makes it more natural the way Excel works now let's see what this is all about I'm just going to use the sample data set and let's make our very first visual to add the visuals we can just pick any visual from here let's go with the column chart and expand this out to build this visual previously you would have to go to the visualizations panel drag and drop the fields there but now we can just select the visual from here you can just click on that little button and then add the x-axis and y-axis data there is these add data buttons right there and you can click on them and then select for example Country and units sold if you do have any measures they will always show up there so you can pick them as well so this is the first thing let's say you're looking at this and you would like to add data labels you can click on this little paintbrush and introduce data labels right from here you don't need to go and find the option from the visualizations panel anymore everything that you want to do always appears right there you don't like the title just double click here and select the title and type whatever you want [Music] if you want to apply some formatting you can just select the grid lines for example right click and then you can change the fill colors line colors of whatever you want let's say you are building this let's add one more chart apart from using these buttons you can always go back to the data view here expand your table and you can still drag and drop the stuff so let's just say I want to see our product and gross sales and we can use the suggest a type option so that power bi can recommend a type of chart for you alternatively you can go and pick your own from the pile of things that we have here let's see how to change the blue color initially I was right clicking but that was not enough so we had to kind of write click a couple of times until this pop-up thing comes up here and then from there you can change the color to something else so it does while introduce a new way of working with the visuals I feel like maybe it's not obvious and we need to work a little bit more to get a good feel of what happens one of the cool features that I like is if you have a title like this you can go select the title you can do some quick formatting by right clicking and applying fonts and whatnot but alternatively you can keep the title selected go to the format Pane and from here you can do full level formatting whatever we normally do and the cool thing that I like is the subtitle feature if we enable this the title gets split into two lines so now we have two level titles where I can put a high level title and then introduce another title for my information and the fun part is both of them can be controlled through conditional formatting so if you know how to write a conditional formatting rule to generate the title for my main title I could do the same with my subtitle as well and make the whole visual so much more helpful and useful for our audience the other thing that they have done is instead of individual panels now all the panels have their own icons and you can kind of switch between them one at a time not a huge fan of this because sometimes I may want to see everything together and it's not really sure how to have both the data View and the format View on the screen all the time so how do you know when you are editing the chart versus when you are clicking on something to do the interaction here is the clue it took me a while to figure this out if you double click on the chart the border around it changes to this blue color box layout so you have four boxes in blue color and whatever clicks you do now right click will open up these format options whereas if I just click on the chart I have the usual black color border around it and any clicks that I do at that point will interact with the visuals and any right click I do shows me this right click button options so what do you think the on object thing within power bi yay or nay let me know in the comments and if you want to learn a little bit more about power ba check out the videos that show up somewhere here on the screen and this thing here click on it to subscribe bye

Channel: Chandoo

Views: 90,750

Keywords: chandoo, chandoo.org, power bi, on object interaction in power bi, power bi new updates, power bi march 2023, powerbi on object, power bi new charts, charting updates in power bi

Id: 5LhYxgtBToQ

Length: 6min 0sec (360 seconds)

Published: Fri Mar 17 2023