 Welcome back to another video. So this is now the third video in our Power BI series and we're gonna continue on from where we left off in the last video. So if you haven't seen the last previous videos, then you can find the link to the playlist below this video. So yeah, you can go check those out if you haven't seen them and you need to get started with installing the application. Else we'll continue this video from where we left off. So we've got our data set here. So this is now put together our three data tables from our base Excel file. But as you can see, it's kind of a bit boring information that it gives us the name and it gives us the setting. But it's not really giving us any meaning information. So you can see all it does is gives us everything by name. If we wanted to keep this table, what we wanted about the summarized by the city level, all we need to do is remove name from our base table and you can see it gives us a summary basically by city. So what we could do if we wanted is leave this table here and let's just do a copy. So let's go to control C, click off our table control V. So copy and paste works in Power BI as it does with any other Microsoft application. I couldn't even make it then. And let's say we've got our city over here in this table. So we can see city and the total sales and the total units. Then this one we want about to give it at the individual level. So what we could do here is just bring our employee name but remove city. So all I did here is drag employee name into the new table. I'm going to delete city like so and let's just make this one a bit bigger and let's just drag up as well. Just so in multiple pairs, why not? And let's just do the same of our city table as well. And as you can see as I'm navigating around, it's really useful because it gives us these red dotted lines. And what those are is it just allows us to make sure that the two tables are either aligned at the top, aligned perfectly in the center. As you can see if I have it down here, all aligned perfectly at the bottom as well. So that's just no great feature available to us just to make sure that everything is aligned if you're particularly fussy about making sure everything is perfect. But having said that, we want people to be able to see and work as well. So we do want it to be as perfect as possible. So now that we've got the two tables, we've got the flexibility. We can now see the summary at the city level and we can also see the summary at the individual level. So let's say we wanted to look at Brighton. All we need to do is select Brighton and what will happen is our second table will now automatically be filtered so that we only see the individuals and the sales available in Brighton. And we can see that total sales in Brighton was 224,400. And if we then look in our people table, so by individual, we can also see that again, yet we can validate that yes, this is just Brighton sales because our total is 24,400 and there was a total of 133 units sold in Brighton. So this is another really easy way to obviously manipulate our data or not manipulate, but break it down so we have a better understanding of what is happening and where the sales are coming from. Again, I keep going back to example of Excel, but this is a real benefit of Power BI. If we wanted to have both two steps as data and the flexibility to dynamically update for us, you can obviously probably already know by now that would be a bit of a, should we say a bit of a pain to have it produce and do exactly that functionality as easy and simple as it is doing here. So let's just move our tables down here because they're all good, they're working fine. So let's move that one there and let's just move this person one down as well. So what we're gonna do is now, as the title of the video is, is we're gonna bring in our very first chart. So what we'll do is we'll just use a chart to summarize the sales per city rather or we'll keep it in the table, but just as an addition to that, it's nice to see it in an actual visual. So when it comes to using any of our visualizations, all we simply need to do is just decide what one we wish to use and select that chart. So I'm just gonna go for a stacked column chart and you see it's added in there. And exactly the same way we populated our table, you can see that we've got now the ability to drag our relevant fields into our visualization. The only thing we need to do is just be clear on obviously where we're putting our information. So the first thing we wanna do is populate our access. So this is the value that's obviously gonna be along the base and measure our timeline for each of our sales. So you can either drag data in here, but for us, we're gonna simply just bring the city into the access. So we can literally just see, okay, for each city, there'll be a specific file chart for each city and in the total sales for that city. So in order to do that, we usually go into locations and drag city into our access. And you can see it's populated city at the top here, so we know information's been captured. And then all we're gonna do is go into total sales and drag total sales into our values. And there we go. As simple as that, we have now got total sales by city available in our visualization. So as you can see at the moment by default, it just sorts all the data by the largest to the smallest. So we can see that London is the largest there with just sort of 16,000. If you don't want to have it filtered or demonstrated or sorted, that's what I'm looking for, in this manner, all you need to do is having selected the graph. If you click the three dots on the left here or the right, sorry, you can see you could even have it at the moment it's selected by sort descending. You can have it sort ascending. So obviously it goes smallest to largest or my personal preference, or well again, depends what you're actually trying to filter on. You can change it so rather than being sorted by sales, you can have it by city. And then by that way, you can see we've now got an alphabetical order, what's quite nice on the eye to look at. So it goes from bright and through to path and you can see each of those total sales. If you want to make any changes to this graph, you know, in changing the appearance of it, all we need to do is go again, having selected the graph itself, is if you navigate to the right hand side, you can see at the moment where we've got our fields, we have this option selected here for fields. If we go into the next one, so the little paintbrush or the paint roller, you can see we're now got the flexibility to make some updates. So let's just go and add some data labels. So to all do that, all we need to do is select this toggle button, so go on to on and you can see that our values have now been added to that graph for us. We can then select our dropdown and this is where we can now change the year. So we can change if we want to be in millions, thousands on them or leave it on auto, what I tend to do. And we can also change the color or obviously what their values are showing in. So if you want to have it maybe in a purple color, then you can see it's purple. Or if you want to have it in white, you can have it in white. Obviously it's not really gonna show up on the graph, but the color I think most of the users will probably be gray like that. So like so. And then we can obviously, you can play around with the text sizes and anything else that you wish to play on there. So that's the color. And then let's go and compare that. And let's say you know wanted to change titles. So you can see we've got the title option available to us. So we've got total sales by city. If you didn't want to have a title, toggle button to remove that. Or you can obviously just change in here the text that you wish to show if that doesn't show you the correct words that you're looking for. And you can obviously go through and play around with all these different options to get the chart to suit how you prefer. And the benefit again with charts is if you want we can obviously move them around and obviously everything is dynamic. So we'll move around and move forward as required. But let's say we again wanted to look at just Brighton. So when we're in this table, we just click Brighton and it filters out a table for us. Likewise with our charts, if you just want to select Brighton for my chart all you need to do is select the relevant column and everything else will be filtered. And it goes both ways. So again, if you wanted to select Brighton from the table or from a chart, everything else on your page will be filtered to match that selection. And again, if we go into, I don't know if I've got any options like this, but let's select the name, let's say Amber. Okay, so then all we see is Manchester. But again, the reverse of that is if we select a name, so the most lowest level in our current data you can even see or update our charts so we can see exactly where that sales from Amber came from. At the moment all 4,000 of her sales are literally just in Manchester, but if she had appeared multiple times and she had other sales in other cities, then again, this chart would be a great way or a table to display where all those sales were. One last thing when it comes to charts, let's say we've suddenly changed our mind and we no longer want to have the stacked bar chart and we wanted to instead have a stacked bar or bar chart rather than column chart, sorry. All we need to do having selected the chart itself is then literally navigate to our visualizations, select another chart and you can see it's updated for us and it's maintained the ascending order, filtering or sorting that we've put on here as well. So hopefully by the end of this video, again, you've got more understanding of how to bring the data into Power BI and being able to start playing around with the different graphs and the tables available to us. So as we step forward in the series we'll be getting gradually a bit more technical with the ability or the information that we have available to us and obviously displaying that in Power BI. If you did enjoy this video, please don't forget to give the video a like and also if it's your first video or if you haven't already, do subscribe to the channel and make sure you hit that bell notification button that way you'll be notified of all of our future videos. And if you've got any questions at all, please drop me a comment below this video and I will get back to you as soon as I can. So thank you very much and I'll see you in the next video.