 Hello everyone and welcome back to another video so I think I've covered a couple bits of these off indirectly in previous videos But I just wanted to do a video dedicated just to working with charts and obviously some of the bits Flexibility that we have with using them. So if you haven't already seen our previous videos been working with a data set That I created it's all just random data basically But if you want to get hold of that you can download it in the description to this video And you'll also find a link to download the power BI application if you also haven't done that as well And likely if you haven't seen the previous videos in this series link to that again in the description to this video Just so you can catch up if you want to go over any of the previous videos that were discussed as a series is built as a Gradual progression so you can start with firstly installing the application all the way through to try to do more complex things with The tools that we have available So the first thing we do is create a simple bar chart or column chart So I say being more specific from some of the data that we've got So let's just add a bar chart and to do that all we need to do is go to our visual visualizations column and Or pain should I say on the side here and you can see if I hover over this one What's four from the left? We've got the clustered column chart So if I just click that in and simply the pop later with data All I need to do is go into country and pull into axis Country from my locations table and that's only because I want to summarize at the country level here And then if I go into total sales, I can then go and drag that into values and you can see it's populated a graph for us So let's just expand that out so sort of not feel the screen But obviously it's a lot easier to see and we can probably go bigger than that Why not so couple of things we might want to do first is we've got these titles around the outside of the graph So we've got total sales by country Total sales down the obviously down the left here because that Demonstrates to us obviously what that value is and then along the bottom you can see we've got another header for country So personally, I'm not a big fan of having the titles on the outside So I'm going to just go and remove those in order to do so all we need to do is go to our little paint brush here All the paint roller Having obviously making sure we've got this graph selected Select our roller and then if you go firstly into the x-axis and Scroll all the way down to the options available there And I'm just going to go to the title option here and just do this little toggle button and change that to off and You can see us now been removed and you probably see I'm going to go with this one I'm going to close that go back into the y-axis this time scroll down and Find where it says title there is and just that one off So we've got rid of both of those so the graph already looks a lot tidier and less busy and just moving those two on their own In order to just change this title we have here. I think it's quite Lanetary really what says total sales by country But for demonstrations purposes if you wanted to remove the title all you need to do is go this toggle button here And it's gone But I think it's beneficial to keep a title just so the user can see what they're looking at and if I expand the Title the first one we come to is this option here the title text I'm just going to just remove title or total from that and you can see we've got sales by country and Oh, if you wanted to get clever with your title text that even mean to click that But you can see we've got a formula button just to the right side here If you click that you can then obviously include values from other fields into your title heading We won't cover that off in this video because obviously I've not planned for that at all But that probably be something that we look at in the future if you're interested So at the moment we've got sales by country and we can see we've got country along the bottom and in total sales and As it stands at the moment our data is just ordered in descending order We've obviously the total number or the largest sales country first going all the way down to the least So United States and Germany be in the least and this might be as you require But again, I'm basing this all upon my own personal preferences and again Just to show you obviously ways that you can manipulate the charts in here I would rather have the countries in alphabetical order Regardless of obviously their size because you can still clearly see that the United States is going to be the largest country for total sales If however, you wanted to just change from descending from highest to lowest you wanted it lowest to highest Or you need to go into these little three buttons at the top right here and where it's currently shown as sort ascending We need to do is go click sort ascending and you'll see everything is updated for you However, as with my example, I want to have it sorted by country We need to do again go down to the sort by and this time select country rather than total sales and You can see it's now been updated for us And obviously we went on to ascending so ascending means obviously a to z But if you wanted it in from z to a so obviously reverse alphabetical order Then we just need to do is just go on to the sort descending option you have available to you there The last thing I probably want to do with this graph is just do some well Actually, there's two parts the first part is to add some data labels Just so rather than trying to cast your eye across these to the left to see what value each one is if we just go into our little paint roller and Go down to where is it data label labels? So just just before halfway down You can see it's currently toggled off Click that button toggle it on and you can now clearly see each value above the column and obviously Dynamically update so as the column shrinks and grows that number will obviously retain that distance above the column and Now lastly thing I want to do is just play around with the formatting of this number So at the moment you see it's given currently given us 0.69 million so it's trying to give the value in millions All I want to do is go into data labels and this time we're going to say where it says display units It's just auto. So it's going to go to the biggest value, which the millionth one I'm just going to change this two thousand so you can obviously go millions billions trillions none So if we went to none obviously you see the full value or Alternatively, you can go into thousands which just makes it smaller So it's whatever preference you have and obviously the more data they have for you the more So say simplified or smaller you want that summary but I'm just going to leave it as it actually is just put it on to none Because that works for this example So that's how we can play around with the sales by country in this example If we do go back to our field setting here The other benefit we have when working with charts is you might want to first say okay Let's make a sales by country and you then might want to copy this and Create one by city and city is going to be quite busy for us So if just get rid of country and you can see obviously we've got all the cities organized there in alphabetical order and I think they are is it just check so saw ascending and let's go saw by City so even though I copied it it still we went back to default So you can see how everything looks by city at the sales level the benefit of this obviously if you click on to France is That's now going to filter all those France ones out for us But as you can see it all it's really all it has done is it's just highlighted the France ones and left everything else in there well Okay, it does that it answers the question we've done here But actually we want it to be a bit more filtered. So when we click France We only see the French cities within this second graph So let's just deselect France for time being and then what I'm going to do is having selected my chart on the left here So the chart was going to be driving at the filtering We can go into data drill. I'm sorry format and then go on to this button here of edit interaction So if I click edit interactions and Then what you can see it's done is obviously this is the chart selected is what's going to drive information But if we now look on the sales by their sales by country apologize, but sales by city You can see at the moment. We've got this option here. What means highlight the values what apply to the selected value We could even get we could get removed so it doesn't none. So when France is selected over here, nothing happens The one we had selected is highlight So when I select France at the moment, you can see it just highlights those French cities But we can go on this left option here, which is filter. So if I select filter what happens now every time I select France Only the French cities will be available to us in that bar chart likewise for Germany Great Britain, Italy, Spain and the United States. So you can see it's a really easy way to now filter those charts One thing you must remember though once you've updated this is just to untick this edit interaction Just so you get out of that edit mode So you have nothing selected you'll see all the cities for everything globally But when one of them is selected, you will just see the applicable cities or the applicable Whatever it may be what comes down in lower in the hierarchy for your selection And I was going to change the title for this so sales by country. This should actually be Title sales by city So we want that updated for us as well Obviously with in this example, we've got a separate city one But let's say you wanted about a drill down functionality all within sales by country So if we select sales by country and we go back to our field option here If we select city and drag that down underneath country at first glance nothing has happened What that now enables us to do is obviously we can now go through the hierarchy of country or Location so I say simply by jotting around these to all these buttons here So we've got some options to us. So we ignore this first down arrow So we've got this double down arrow. So this means go to the next level in the hierarchy So if I select that you can see it goes down to city So I can either go this up arrow here to return to the top or if I'm going to double arrow It will take me to the next level in the hierarchy So obviously brought both country and city now contained within one graph So this is really useful again if you've got a lot of information You're trying to display on the sheet rather than having a hundred and one different graphs You can capture a lot of information at different hierarchy levels or within one chart So we go back in so we've got the end so the up arrow always takes us back up So the double one goes to the next level in the hierarchy The next one along here go expand all down to one level in the hierarchy So again, it just takes us down to the bottom But the real beneficial one I find here is you see this second arrow What says click to turn on drill down if you select that you can see it selected because it's highlighted What will now happen is when you select one of these countries it'll automatically drill down to the next level But also filter that information as well So if you select France you can see it's drilled down But it's only now showing us all of the cities available within France So if I go back up and now this time what I'm going to Germany you can see how it's now filtered to Germany So this gives you another way of working with the chart rather than having this second Chart over the side here and the reason that's not so desirable is as you can see at the highest level when everything Or nothing is selected you don't really want this big chart over the right here Was just taking up all this space or just looks really messy of all this data You can simply achieve that by having the drill down turned on within one chart and being able to go through each of these levels Countries as you decide so having done our formatting with this particular graph Let's say we wanted to change the type of graph we're using All we need to do to do that is select our chart and then we can navigate to whatever desired chart We want to go to so let's say stack bar chart and you can see it's now updated to the stat bar chart and Some of these columns so we've got like such stat column charts and clustered bar charts a lot of these require us to have more Data in terms of obviously a legend. So obviously at the moment. It's just So what we could do to do an example So let's say we've got our stacked column chart here Let's say that we wanted to bring remove city from our drill down options and put it into the legend You can see how obviously what it's now done is it's given us a breakdown of the country Obviously total sales and it's broken down the city into each one of those columns So that's the benefits of using the stack charts Probably not so beneficial for this I probably revert back to what we're using before about the ability to drill down But that's just to show you how to use that if you wanted to and then the point the last chart I'll just quickly cover off is the pie chart I'm gonna say these are the most sort of popular charts You could say without using like line charts what we're going to a separate video If you want to change to a pie chart or you need to do a select pie chart and you can see how Obviously that updates us for us as well And likewise we still have the drill down facility available to us So if you wanted to go into France is blue on here You can see how now it popped updates and gives us the city level for France If we were quiet so drill down mode works across a lot of these charts And it's a really beneficial tool for us to use so as we looked at in previous videos when we looked at just data in tables We had the flexibility of being able to play around with the amount rather than having to add additional fields So the moment we can see we're using the sales The sales data to generate the total sales per location But let's say we wanted to actually look at what the average sale amount was The total number of sales or even the highest and lowest sale amount for even that country All we need to do as we did in our previous example with the tables is having selected the table Navigate to our values field what says total sales do our drop-down and you can see we've got a range of options available to us again So if you want an average or you need to do a select average And you can now see the total average sale per country or if you wanted maybe maximum you can see the maximum sale Maybe the minimum sale or lastly in this example You might even want to see the total number of sales so again all that flexibility is available to us in the charts as well So I know we didn't really go over all the broad spectrum of the different charts available to us But as you'll see obviously each one has probably its own Personal beneficial use and it's probably only worth going to those when we've got the data to go through Rather than trying to maybe create something that isn't as easy to follow Just for the tutorial sake but again I hope you enjoyed that video if you did please do give the video a thumbs up It'd be greatly appreciated by myself if you haven't already subscribed to the channel Please do that now and make sure you hit that Bell notification button So you're notified of all our future videos as they come out if you have 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 for watching and we'll see you in the next video