Fleet Management Dashboard in Power BI Step by Step Tutorial (Part 1) How to Power BI

all right everyone Welcome to our next power bi dashboard project so in this particular project we're going to be dealing with Fleet Management so um we're gonna see how we can actually create this dashboard from this scratch so before we actually do that we need to actually look at what exactly does the client wants to see ask kpi and other information we need to get before we get started from the scratch this dashboard will definitely teach you a lot of things that you need to know and actually implement it on your own personal project so let's see what is the need of our client before we get started before we get into Power bi and start writing Dax let us look at some couple of things we need to have in place and to know before we get started the first one is our design we're going to create a design just like what you're seeing on my screen right now and the next thing is understanding the expectation from our boss of Markland in order for we to actually create a dashboard that looks like this we need to understand what the client wants so let us look at some couple of you know kpis we need to track so the very first one right here is actually all it has consumed total drives total kilometer traveled total fixed costs to tough well consumed and maintenance cost so we have a other kpi which is particular to that of the driver's kpis so we're talking about the average speed per driver average fuel efficiency fuel consumption per kilometer then fuel cost per kilometer so after all this we need to add some couple of slices then the first slides that we're going to add would be truck type and the trailer type so we told this you're good to go if you think you can do this all by yourself just get the data and pause the video and actually create this and let's see what you can do then if you have any problem then you need to actually watch this video till the end and solve it all by yourself so if you have not subscribed to this particular YouTube channel before go ahead and do it and make sure you download all the files you need to help this project created alongside with me welcome to data with decision foreign [Music] CSV inside data so let's go ahead and grab this data so what you can do for the first time is for you to actually click on import table uh from Excel so click on that and you're going to see the two Excel workbook you have let's go with our F cost right here so the F cost tends for fact table cost so on my table cast I'm gonna get this particular one right here so I will click on this very part and I'm gonna click on transform data okay everyone there you have it so the very first thing I love to do if I have you know semi-clean data at the time sure like the data is very clean and I'm very Speedy about it so I'm going to do Ctrl a and I'm gonna go ahead and click on transform here and I use the text data type right here so I'm just gonna fix any data type that are not really right for me so the next thing I'm going to do right now is to update this particular part so I'm gonna put here then the remove up to this level so instead of me to put fkm travels I'm gonna put facts table travel here so I'm gonna remove this and let's come here and have an underscore I just love doing that so this is our first table right here and it's okay so the next we're going to do click on home and go to this particular new cells and click on this particular Excel workbook so let's go ahead and click on this particular you know dimensioner tables then open all right let's go ahead and pick the false uh the last three so like from here downward so the rest are the same thing but on different languages I don't know I don't really get it so I think the last three is watching it so go ahead and click on OK so we have clean data as well right here so just go here and do dim for dimesh not table underscore customer and do that to every one of the tables that actually damage the tables as you can see I've done that to my vehicle and my drivers as well so let's go ahead and pick their many tables so this time around we're gonna go for CSV so the average right here is what we're going to pick go ahead and click on OK so here's our last table so for the first F that is small letter what I'm gonna do now is to remove it and use Fox table for the name and I love using on Disco you know that so just click on OK and there you have it so we have all our data ready right now so what is next we have to load this data to power bi so let's go ahead and close and apply it's going to take just a while it depends on the speed of your computer [Music] all right right now we have all the data that we made so let's go to the modeling view right here all right kindly verify your relationship if actually hover over this right now you can see we have customer ID to customer ID in the fact table Freight and if I hover over this particular one which is dimensional table Vehicles it has track ID to track ID in the two table fact table Freight and if I hover over the same table vehicle you're going to see that it has the track ID connected to the truck ID in fact table kilometer traveled km means kilometer traveled I'm coming back right here if I hover over it driver to driver import table so what about this do you have the same thing so we still have one table we've not actually created yet and that is going to be our date table which we are going to create in a JV so let's get to the visualization path so clicking right to right now let's get to understand exactly what we're about to get into so going to refresh to want to click on it and there we have it so if you look at this this is exactly what we're going to create a very simple dashboard indeed so but the very complicated part is actually the tooltip that you are seeing right here so for all this one there's simple kpi that you need to actually know how to create like those four right here and even the one on this particular chart which I'm going to create and show you exactly how I did it so let's quickly go back to the one we are creating by going back here we are here already so the very first thing we're going to do is to come right here and click on the driver and just click here so we have this driver as a table for now so we're gonna have it let's see so here we have our drivers before we start writing an immersion I love to create a measure table where I store all my measures writing so the very first thing I do is to click on modeling there are so many ways to do this but this is one of the best ways you can actually do it so now you're here go ahead and click on our new table inside of a new table let's just actually create a measure table measures table and what you're going to do is to use this with your glass I think it's square bracket I presume inside it use double quotation type in a letter of your choice into it unclog double quotation and click on this square bracket once you've done that go ahead and hit your enter oh this is not square bracket actually this is actually curly bracket I think I don't know if I get that right it's not square but the color bracket is what you need to use oh it's not working I think made a mistake somewhere let's do that again so we do measure table we do this we can put anything I want to be so let's see to enter key once again oh got a trunk now I think what we have gotten is the equal sign before we do this particular color bracket and inside it put anything you like and close then hit enter key let's see if that works right now when you forget one single thing probably I can actually get your lives and kind of miserable so we got to try it right now for the last time so now we're gonna store all our measures right in here so before we start creating measures and all of that let's go to our data View and see what we have right here on the dimensional table we only have what we can use to slice and dice our data so the same thing we have on the driver we don't have anything like calculations right here but we can do it count right yes of course let's go to dimensional table called vehicle so we don't have any figure numeric values right here for any arithmetic whatsoever but only two fact tables we actually have right in here this is where the big one comes in the very tape we're going to use for the fourth time is this particular fact table kilometers traveled right so here we go we have about kilometer traveled we have the liters we have the fuel so now if you look at the fuel here we have is like um the difference between these letters and the floral here is what you need to know so the list has the amount of letters used for part trip yeah per trip and the four here is actually how much is being spent in purchasing days and running the operations you get it and we have the maintenance and the fixed curves you need to understand this the maintenance is actually how much it takes you to actually maintain your truck that you use in Combined us you know goals and stuff like that and the fixed cost is what you don't actually have you know uh how do I put this what you don't have control over like the insurance and stuff like that is exactly what it is we're gonna be creating this and after this we need to run some setting you know uh Advanced analysis to know more about our drivers so first of all let's see what we're gonna do we're gonna use some on all of those columns right here which is very simple and I believe you can do it let's get back in here so we are here we first of all click right here now once we right click on it and the first we're going to do now is to just go ahead and click on new measure so the very first measure is to calculate the total kilometer travels which is going to be total km traveled so now you know what km means that is kilometer traveled so you're just gonna do your equals and uses some function and all you just do is to actually reference the right table and that's just gonna be uh when you just type in km you're gonna see km travel here and once you get it here we get it so total kilometer traveled you close and you hit your Enter key that gives you the summation of the total kilometer traveled by all of our drivers to have this right okay let's do the next one all right all these simple measures we're going to be using have been created specifically the total drive if you look at it with the we did the count on the driver's ID from the you know um what I call it from the drivers or table so you can see dim drivers so to know how many drivers we actually have and right here we have the fixed cost and the fixed code is simple it's a simple sum of default table kilometer travel table so we have a fixed cost sitting there and we have the total for consumed and one thing you need to understand is that total well-consumed is actually going to be formatted in dollars here I told you it's not actually the numbers of well consumed but the value of the flow consumed then kilometer traveled is going to be formatted I think we have that yeah dudaculator traveled make sure when you actually format any value you'll use zero to remove the extra decimal places you have on it so I'm going to come back to kilometer traveled right here on the kilometer traveled here we gonna have it on comma separator and we have it has consumed it has consumed comma separator as well then total maintenance cost right here is going to be uh on a dollar you know number formatting and I'm gonna take off the extra decimal place out of it by putting zero on our Auto right here then hit your Enter key for now those are the measures we need to create Hit just like this is okay very simple okay it is time for me to get those merger inside this table for the first time in order for we to create something as beautiful as what we have right here right now shall we of course I know we need to do that let's get it so we are back right in here so the very first thing you're going to do click in here and let's get it from the I think I'm gonna go from this particular data traveled so here we go we don't want this I think we have a blank now we don't want to use this particular kind of charts so we want to use table and not metrics but this kind of table right here well if you look at it something is a bit wrong right here let's go and see what is exactly wrong if I go over to this particular Model area so if I hover over this place you can see we have driver linked to our driver ID which is absolutely wrong that was why I never leave you know power bi to run the relationship for me so what we can do now you can double click right here and see how to fix this so we're right here so here's our driver ID we need to actually make sure we match it with this driver ID by the time I click on my OK key right here let's see what we have give it some time then let's go back to our report View that fixes exactly this place for us so let's go ahead and expand this so we've got to know kilometer traveled the next we're going to get right now is totally consumed so we go for liters consumed here then from there we actually go for the fuel consumed so we can go for maintenance and lastly we go for the fixed costs so we're not taking the numbers of drivers because already we're using drivers here as what we used to slice all those particular figures so after you might have done this for you to actually have a nice table what you can do right here is just for you to double click on this one so once you double click on it is actually for we to go ahead and make sure we remove the total out of it so the next thing is for the latest here double click and take off the letters um sorry the total by leaving the letters consumed so the next thing we're going to do now is click on this one then take off the total well consume is what we want so this would not actually you know uh have anything to do with our our original mergers so original measures are actually cool so maintenance class is what we want we don't want to turn maintenance so just take this off and finally we want to fix cost right here not total fixed cost so we take this off here we go so you can see we've shrink this the way it should be so I don't want to see these particular filters here just for me to have a very big space to get my things done so we've taken that off so first of all let's move this this part let's go ahead and click on this and let's go to our oh no we can find that so we just have to go to view from View so click here and now we can go to size so let's use six to four six two four four height and we'll do that by you know 662 this is what it is so six to four by six is to so we need to create a white space for the bottom and for the edge here we need the white space right this is exactly going to be what we want so once you have done this we still have some touches to do before we finally got exactly what you have gotten from data one so let's go ahead and affect the value so I'm going to do the value to be uh 13. so that thing is okay for the value that is fine so next is for you to get to go to the grid here and let's make it five so we're gonna make it five this is what we have so I want to take off the total let's do it the total should be turned off that is gone then let's go to our header so we milk I had a 10 but select a variable font for it so we have something like this which is cool so for now let's do with what we have so I want to remove this particular you know horizontal and the vertical scroll so let me click right here just move this a bit and as you can see it's taking it off so it's almost gone but I don't want uh okay let's see yeah sure let's fix it because if I do that it's gonna actually call this down so I can just do this and you've gotten that off so we can just do this a little bit so this one is gone as well so for now let's have this so enjoy what we have now so once we have done this the next we're going to do right now is to get a line chart right here but when we have a line chart how do we visualize our line chart that is going to be something you will have to talk about so I'm gonna break bring in our line chart here so for now we do not have edit table so how do we visualize online charts so that type is very simple to create I don't want to use the inbuilt Dell table here let's go ahead and build it so here is my previous date table I have used on the other dashboard so you can go ahead and copy the same exact thing if you need the code I'm going to send you the code copy it paste it and it's going to pick the right date for you so let's do that go Ctrl a and Ctrl C to pick it from here very simple and easy so let's get back in here now we are here the next thing is for you to click right at the details view and let's go to this particular table tools and click on new table foreign go ahead and just paste it down then hit the enter key and we have our new date table so with this dead table let's go to the modeling view quickly but before we do that let's click on this particular date highlight the date column here sorry the month column brother so go to this particular sort by column you have a month number go ahead and start it by month number that is all going to do for now but this one is not really the way I want it I can actually click on this particular one and use this short date format by clicking on this part here you can see the date here is the short form so click on that so after I might have done that you have one more thing to do let's do it so make sure you still have the table highlighted go ahead and click on table two and here you see where it says Mac as date table go ahead and click on it and yeah you click on it Mark as date table wait for it to come up so with this that's validate her successfully so click on OK let's go to the modeling View and do one more thing so click right here go ahead and close this so we have a date table here you can bring it down so let's stick this up so here's our the table I'm gonna move this away move this to the side and now we can bring in my date table here so clicking on my date table so let us look at the tables with that so we have the two fact tables we did this one and this one right here so all we have to do is to drag this and put it on top of the date here and that will definitely create one too many relationship for us or many to one relationship whatever so you do the same thing now you can calculate start from here either of it will definitely work so drag it on top of this and surely enough you have just created a date table for you work so I can just go ahead and do this so nicely done so let's get back here so this time around clicking on this now I can surely go right here and I will see my new table so all I need to do is just to actually get my date but I don't want to use just one I want to actually have you know this drill down or drip through is it really trade right now I think it's drilled down not real true so drill down effect on it so what I'm gonna do right now is to first of all pick my uh let's go with my ear so on my year I can create a hierarchy here create it so it's creating the hierarchy for us the hierarchy has been created but I can rename my hierarchy I don't want to use my hierarchy as year hierarchy so let me name my right hierarchy to mons so [Music] months that doesn't mean I have two minds I'm gonna move my month into it as well so the next thing I'm gonna do is to move my mod into it and where is my month my month my month okay I've clicked on my mind to move it now click on ADD hierarchy so let me do that again for you to add your month go to month it doesn't matter if you click on it all you have to do is to make choice on highlight right click and uh create no but add you can see the month here which is the rename we just renamed click on it that would have added this month into here for us so the next thing we might want to add right now is our quarter right so let's go ahead and add our water so right click and you go to add and you add the quarter into it so do you see that right now that is it if you want to add a date name you can go ahead and add the name but that is not really important to what we are actually analyzing so for this very purpose I can go ahead and click on my should I call it group or hierarchy my hierarchy of course so our hierarchy is in here so it's not really visible right now but is this actually visible right here we have the year the quarter and the sorry the year the month and the quarter so what do we get into here so if we go ahead and collapse this I can just decide to move my which is awkward right why is it happening like this what do we have right there we just have one year of data so I did this because it will have multiple years it would then balance your house which year is trending so now we can go ahead and some kind of drill by month by quarter okay we do this by order so we're seeing here so you can see we have the quota as well can you see it now we're gonna see the quarter alone so here's the quarter can you see you see the quarter alone here's the quarter but what we want to do is just to leave it on the month so the month is fine we love the month but this is not exactly what we want so we want to actually have the feel of like we select you know kilometer travel lit has consumed how much it's been spent and the fuel and stuff like that how do we do that let's do it so go to the modeling here before now it had never been easy you have to write the ducks that I'll do this for you but right now it's far far simple so click on this particular new parameters and we're going to use a field parameter right now Fields parameter click on with and let's see what we have so this is exactly what it is so I want to take it up from here and this is the Box we're going to be using but before we do that let's highlight this parameter and rename it to uh switch switchable driver okay switch driver [Music] measures Street Driver mergers we have it let's go we open our measure table and now we have to get all of this in so I'm going to start from this totalities followed by or total well let me go with two dimensions well consumed I'm taking it based on the length of it so we get this right so my argument is not really compulsory it depends on what you want but this is what I wanted of course so no matter how you pick them they will definitely work like magic so now we have gotten all our measures right in here so the next thing now is to click on create that will definitely add us um should I call it a slizer yes of course it's going to add as a slicer now we have a slider right in here I don't like the slider if I select this right now or no this is what I'm gonna have so let's fill this in and let's see what we have so I'm going to take off what I have in here and now it's gone so if I come in here right now um check this let's see what it is nothing is selected because it's empty let me just go ahead and select something and see does that work that seems not to work let's check it out where is that right now we scroll down can you see we have it on the legend so we don't want to take this into the legend so let's see we're gonna have this if you look at this right now here we have the x-axis is taking the dead so the y-axis needs to take this so we can try to move it and see if that moves definitely it worked but this looks some kind of ugly why do we have this that was because we have nothing if I say nothing I mean we have nothing selected what do we do let's select something here and see you look at that this is exactly what it is is working but if I deselect it and select multiple that shows that I'm selecting multiple and definitely I don't select multiple but if I want to select multiple right now I can hold my Ctrl and I have to select it it is so it's kind of fine it's okay to compare but definitely I hate this what do I do in this case let me show you um go over to here now we are here can you see the slider settings right here click on that then we click here and we check this particular drop down for the first time now we're on drop down and we still have multi selection right so what do we do next we click on this selection here and we just go ahead and do this so that's actually I'll only allow us to select one item at a time so if I open it up right now I can hold my Ctrl key and select multiple of it so now I can resize this and I definitely I don't need the header you can take off the header I want it without a header so I'm just gonna have this right in here so let's just drop this down and for this particular chart I don't want header for rates or title for it I'm going to take off the title so first of all I would love to resize my chart and take off for all I don't need because I want my chat to look as beautiful as this one right here let me take you right here and see what it is that we have done here can you see this right now this look beautiful but we have to do a lot of work to actually have it the way this one is right now so let's do it so click on the size here and uh here we gonna make it um I think let us make this one five three three and here we're gonna make this one two nine five that is what it is so we come down to our x-axis here you know the excess is right we want to take up the title now we click on board right here to bold it so close it the x-axis we want to take up the title as well no title for it diesel you don't need to do anything else so now we have achieved this so I can just move it down a little bit so let's just use this for now okay the next thing we're going to do right now is to actually create some kpi cards that we need for our works let me bring this down okay for the kpi card I'm gonna go with this card here so in this card I want to have my totally task consumed so I'll go over here so I have um liters consumed here we go I bring it in it's gonna make it a bit smaller so first of all let me just quickly you know clean it up it's very simple so let's click on this here click on this so we go over here we just make it 25 and that is it so we make it a small just like this so what we can do is just uh okay before we do we do copy let's go over to this and turn off the background we don't want that right so we can now go ahead and copy and we have it pasted so we can bring this right here so once we've done this the next we're going to have right in here right now is total drive so you click right here and move this off so we bring in total drive so we paste on that one so we bring this over here and this time around we want to have um kilometer traveled so we go over here and then we have our two dot kilometer traveled so these three you know cards we have here now I want to make sure they are very well aligned so let's bring them down a little bit just like this so now for you to have them aligned right now what you can do is just to have all of them highlighted go over to format and click on align here you go over to distribute horizontally and that is very cool right so once you've done this you can select all of them at once so I can just go ahead and copy I paste it down so I'm just going to go ahead and move all of this down here so don't worry about the arrangement right now in no time we're gonna have one of them clean up so once you have done this the next thing you're gonna do right now is just to actually have this one change to watch when so quickly click here so fixed costs will come in here go over here so we're taking our fixed costs so click on this click on this we do this and click here and this one would definitely be total com latest consumed so here we go so to delete that's consumed so I think that is not too well for my okay not let us consume we've used that already before now I think it's gonna be fully consumed that will be in value like in dollar formatting [Music] this should be formatted like this then when we click on this one this is going to be of Maintenance codes right yeah it's going to be on maintenance costs you can take it off and go into it we go right here we check this so that is all we need to do so we've got the demo okay nicely done so the next thing right now is that we have to start creating the template that we want to use with this I know the right place to do this is not here but we can use PowerPoint to actually have something very very you know creative created let's see something here I don't like this what am I seeing I'm gonna just double click on this part just make sure you place a console here if you have this that opened this up for you so it has stretching it up so nicely done okay let's see that I'm gonna drop this down a little bit yeah the white space here is okay I want to have a specific top level right here so the very first thing I'm gonna do right now is to see right here we have what we call snippy tool go ahead and make a search here is a Windows 11 or 10 you can find it snippy tool is a tool to take a screenshot so just click on new and over here you take the size of this dashboard right here so once you actually have this red surrounding this just like mine then on your computer that is fine release it so you have taken a screenshot so here you go save Savers I want to save it somewhere I can pick it up from easily so I have it right here I can remember exactly where I have it saved in on my desktop so go ahead and click on OK so we can take this off so now we have to go to PowerPoint to actually start getting things done the way it should be all right welcome to PowerPoint environment the first thing I'm gonna do is to have everything in here been removed so I've taken it off so the next thing I'm gonna do right now is show you how I get my color already I have my colors right here so I've already picked all the colors I need I'm going to show you where I used to get my color from in case that I have an inspiration for colors and my clearance does not have the color inspiration as well so we can pick color that rhymes and correlates together let's do it so go over to Google and actually type in uh Adobe tinker type in Adobe dot colors here we have it adobe.colo.com let's wait for it so you can see the first one right here go ahead and click on it so if you open it the home page gives you something like this but this is not exactly where we are going so go to explore click on explore and once you are in explore you can see the default colors it mixed up for you so you can use any of this if you think this is what you want to turn all of that just go ahead and use this but for we if we want to get color now we can search for the color we want over here you have a sidebar not this sidebar place we have a sidebar inside web page itself so click over here you can see the previous searches I've made so right here I can actually use like a or blue uh comma I can use orange here so hit your enter key it's going to mix this up with other four different colors or or sorry three different colors all of that so you can see if you check this one right now let's see Pablo here under blue something like black orange and it mixes it up for you so you might not use all of those colors you can choose the best three or the best for the videos this is how I get my colors another thing you need to understand all you need to know is actually where I get my icons from I always get my icons from PowerPoint but if I don't have the well the very one I need I can come over here to um something like this flat icon.com here on the flat icon.com you can get any icons you want to tell so let me just get something like a Analytics so you have over 80 000 analytics icons can you see them over 80 000 analytic icons so here you have them so the very big part of it is that you can actually get not just icon animated icon if I click over here you go to animated icons let's see what we have on the analytics so let's say I click on this one for example if I want to use this right now let's see let's see it's coming up can you see that very interesting let's click on this and see what it is can you see it now you want something like money you got it it's coming up let's give it some time so there you have it so I have some videos where I've shown you how to use them on both Excel and power bi you don't just put them into excellent power bi and you think it's gonna work so you there are ways to actually get them in but enough of this let's get back to our power point okay here we are those are the colors I said we're going to use the first color to be used is this particular color right here let me just copy this and come over here and drop it in here I'm going to show you the color code in case you want to use this exact color so the very first I'm going to do is to click on my background not on this but on the covers so right click you see where it says format background here we go click on it so we have this right here click here and use this particular eyedropper so once you've done that click on this that's exactly what you do so now we click on the very one we use to get this created so we can now go ahead and have it deleted because we don't need it again right once we have done that the next thing I'm gonna do right now is to go back right here look at this yes I'm gonna copy this Ctrl C to copy back here contribute to paste we have it right in here so I'm going to resize it over this place and stretch it to this level do you see that this is exactly what I want so in case you want to see my color code let me for this one here for the header click over here more colors and you look at this is zero zero three five four two that is the color you get it so click over the background itself here we go if I click on this particular one here it's giving me zero zero four one five one make sure you have the harsh tag right there so we've gotten this already that is beautiful the next thing right now is to bring in our what bring in our screenshot so go over here so wait for it here we go pictures this device so we scroll over to where we saved it in desktop if I scroll all through I have it so here we have a screenshot we want to actually go ahead and resize it make sure it covers to this level that is beautiful so once we have done that all I'm gonna do right now is to right click and actually click on Center back so that's reveals exactly what we have on the header and I'd love to hear that the way it is right now so just leave it just like this so once we have the header this way what else do we do we can actually go ahead and pick up a card here we go we go over here then go go to ships so we click on this particular one that has some kind of rounded rectangle drop it down so here we go we have something like this do you see it now so for we to be on the same page let's some kind of use the dimension height and weight what do you do let's do it so click here go over here let's do 2.5 centimeter so we do that by what by 4.45 so here we go we have something like this so after event I've done this let's go over to um here then for the outline we don't want any outline for it so for the main color here we can definitely use something like this this is the color we want to use so we can bring my color over to this part let me rearrange my color this particular one here so for direct for the rounded corner I just want to reduce it so we can just click on this so we don't want to have too much right something like this is okay so now we have this click and double it double this as well so the next thing to do right now is to definitely make sure we click and highlight three of them go over here and you see where it says aligned and we want to distribute horizontally and we can do align top align top here we go that is it so once you have done this the next thing now hold your control key you see this plus sign drag it all the way down right here so you can see you can just move this down a bit so the white space at the bottom is always okay you need it so once we have gotten this ready release your cursor double click on just double this and bring this all the way to this level you do this you bring this down so if you look at it right now we have some kind of two rounded corner so I'm just gonna like take it off totally I don't want it at all so now we have something as flat as this so we make sure it's in the middle so this is beautiful um the next thing we're going to do right now is Ctrl D to double it so we come over here so we do this so we just get this done this way okay we'll make sure we drag this all the way down so we'll we have a guide that guides us through if we are at the right spot in terms of horizontally and vertically so once you see that red dotted line just release your cursor that means everything is right so don't worry about if we have some part of it with above what we have just created that is fine you get it that is fine don't worry about it okay we have something like this and uh I think I'm very very much cool with this so all I'm going to do right now is to remove what I have behind it can you see it now just click on delete and we have something like this this is not yet perfect we have some kind of shiny part of it that we need to create let's start from this card control it to double it so here we have it if I go over here now I control C to copy come here and contribute to click uh just drop it in here now click on this and use the eyedropper then pick it up so now you can just go ahead and have this one deleted we don't need it any longer so I'm going to contribute it to just duplicate this very interesting so come over here and place it right here so once we have just done that the next we're going to do right now is to make sure we actually have it on top of it so right click and send it to back one beautiful thing if it has not well some kind of arranged you can use your arrow up and down to do that so I just want to actually make sure it shows a little bit at the left hand corner once I've done that I release and this is exactly what I have so I come over here to do the same thing send it to back send to back now we arrange so once it disappears one two we have this we can have yeah this so can you see it now so the next thing right now is to do this one contradito duplicate it once you've done that we come over here instead of us to use this we are not using this instead we are using the gradient fill here we have the gradient field right here so instead of first using the first stops I'm going to take one off um there use the middle one I check this I use this color this color for this part the eyedropper which is this very color for me then click on this one the Hydra patches this color for me that is beautiful so the next thing right now is to check how I want this to show so I'm gonna use this one then that wouldn't make me two do something like this can you see that right now so on this part here you can just do this so put it on something like 80. I'll come over here and do something close to that so what I'm going to do right now is to make sure they are resized and they are on the same level if they are not I see it right here just send it in a little bit and uh let's see this the reflection is fine that is beautiful we're gonna leave it this way okay I love what I have right now so I'll contradict to duplicate this if I click on this gradient fill I'm gonna have something like this the next thing I'm gonna do right now is to turn it around to actually get exactly what I want this middle one or this very one is okay so I have something like this so I just make sure I put it on top of it right click Center back so now bring It Forward so once it shows this it release this go over here and do the same thing now you choose this you just go here you choose this here and [Music] right click and send this to back so you just bring it down a little bit so you can use it right now don't make it shoot too much it will be some kind of too awkward this is actually okay so we're not done yet we have one more to go so all we just need to do right now is to go over here and um go to ships click on this circle hold shift key down to draw a very perfect circle right here so now we're going to check the height and the weight of this very cycle we need to use let's go here and here we're gonna use 1.3 by 1.33 so once we have done that now beautiful we just have to bring this over to this level let's do this here so now we say no fill so we come over here under this place where I want to have a fill on it so we choose uh let's do gradient and I'm going to take off um two stops some left foot one stop oh yeah I'm left with two stops right so I'm gonna choose this one and over here I'm going to choose the same background for it and over here I'm going to choose how the reflection should go I want something like this this is how I got this right so the next we need to do right now is to make sure select it contradict to duplicate it bring it over here so we bring this down so just do this so just set this around here you go okay I might not be perfect when it comes to doing this but spend some time arranging this so I'm gonna come here select one of it so make sure you have one selected hold the Ctrl key to select this one just select this one select this one so go right here to arrange it and you can align it up align top that is nice so now you can do the same thing to this one just spend some time doing this so do this so Target data selected and then you go over here and your line this to the bottom so that is nice so well arranged so we need some icons right here I'm going to show you I get my icon right here inside PowerPoint so go over to insert and click on this particular icons so once you've done that let's see what it is that we have right here okay in here if I type in Analytics so I'm gonna have all the analytics oh no here we go we should have it so I have all the analytics right here all you have to do is to click around and get exactly how many of them you want then click on OK you are going to have all you have clicked on right here so you can decide to change the color to something like this so you can see I can resize and reshape all of it so can you see it now but I don't actually want all of those icons I brought in right now because I have already some icon down to be used so just go ahead and get to whatever places I've shown you to get icons from and colors from to make sure you have all you need to get everything done foreign okay here we have the icons here all I need to do is just to arrange my icons to be well into where I want them to stay and sit rightly okay so we have those icons right here so this is exactly what it is that we want I'm gonna tell you first thing that we are almost done with days so I have one thing left and that would definitely be what what I'm thinking oh let me go to insert and I'll click on here I want to take up this line and I'm going to drag the line hold my shift key to drag in this line here and I'm gonna use the let me use the gradient line here so take off one stop and this one is going to show this this one here is going to show the same color which is the same background color so while the middle one all definitely show that shiny color this very one here so for this one we have to reduce the transparency you know to get the actual kinda you can just kill it let me latency does that work for me yeah that should work if we change it the way it looks here we go we have something like this do you look at it nicely done so let's go ahead and try this and see if this definitely fit into what we want beautiful so we have actually created everything we need to actually use okay before we go let me do one more thing I want to come to this place I just want to copy this color code because I need it it's very important it's one of the leading color I have so just do Ctrl ceter copy so as you can see it's seven one e for FL so no problem we've gotten it so next we're gonna do right now is to go to file export and we click on this so I don't want to do as PNG I'm gonna do jpeg double click on it and let's save it somewhere I'm Gonna Save this as BG one so we just click on Save so just click on OK so let's go to Power bi so now we are here so make sure you have nothing selected here just go over to your um canvas background bring this to zero percent so click over this here let's go ahead and pick up BG scroll all the way down and there we go so we have this nothing is popping out the way it should be like now because we are not doing the right thing by leaving this on white but it's cool we can do it let's do the first thing so make sure you select this select this this this this this this your multi-selecting right so we go over to this and here we if you remembered we did copy or something so paste it over here do you see that right now so we're bringing the ship out so the next I'm going to show you now is still make sure you highlight everything turn off the category we have them turned off so now we can manually arrange them so let's do this so just put this right here don't worry you'll enjoy what we're doing so just have this right here foreign [Music] Follow My Lead do everything I've done so you have the same result as me so just do this okay so you just do this so now the next thing we have to do now is some kind of just leave it the way they are um [Music] make sure you go over here turn off this then go right for this uh thing is the x axis first so we want something like this so the y-axis so we don't want to add this to overshadow the X so we're going to look for something that is not as shiny as that something like this would be very cool so once we have done that that is great the next right now is this one here foreign so what we need to do now is just to make sure uh we click on the value here and then the value we make sure the value is on this 10 dark white so we click here and we turn off the background okay so for the line chart here let's see what we have with the line chart the line chart we want to change the line charts color so we go over to line scroll down we look at the colorful line chart so we pick this color that is beautiful so uh if you look at it now we have line type I want to pick up this particular smooth line and I have something like this so what happens if I have this place open can you see we can't pick nothing because it's not visible what do we do so we want to get the same exact color we've used let's go ahead and get it so here is the color just click pick up the color code from here so it takes time to create a very beautiful dashboard so you just have to be patient with sit just yourself and have a very you know precious time to waste yeah so click on this now and let's go to Value we are on the value sorry yeah on the value area let's move the background we're right here so now we click on this we paste in the color code can you see that so let's see if I click on this now so you can see it reflects everything here so when I make changes so it's actually giving me exactly what I want so the next I'm gonna do right now is just to make sure this sits right so when you want to get exactly what has been selected showed up here this is what you do you don't go over to a card and put this in then you come over here you do this this is the wrong perspective to do this it's going to show you numbers right so this is going to show you numbers it's not going to work and what we want is to show something like this let me go here and show you what I'm talking about so if you look at this right now can you see this now if I actually select something different like if I go for my total later asking Zoom right now you can see totally task consumed is this can you see that this is exactly what it is so now how can we show this we need to actually show this right so let's do this so I have to get it deleted remove so now what we do is to click on this and make sure you copy and paste it back right in then go over here and drag it to all this level just drag it up to this level as well so once you have done this you turn this into a card so you're gonna have this right so let's go ahead and make sure we put it on take off the category so we come over here let's put it on 25 and see what it is so 25 seems to be cool right can we use something like Teddy so let's see if this is okay the next we're gonna do right now is to get the same color we used for this right so I think that is not gonna work I think I have a specific color for red let's get it so if you click over here you can see this color is a different color we've never used it before so I'm gonna go ahead and get the color code come over here and now you have zero zero nine is BB so Ctrl a control C to copy so we go over here now we click here so this is exactly what it is so we've gotten this right can you see it now so let's go ahead and move this up a little bit so what happens if we select something that has more position up or everything no so after that case we need to change this to 25 let's see what 25 will give us okay I think this is actually cool this is cool we love this so this is exactly what we're gonna do can you see this now it's looking beautiful okay next we're gonna do right now is to click on this part and now we have to go over to here and first of all turn off the background the next thing we do is to come over tool uh this part here once you open it up you have options to actually give a color to your background and to the text and we have a tonic colors right so first of all let us deal with the background so the background we use for this particular one right here is what we're gonna use so let's see how we can get us in background then we're going to click over here and we choose background to pick it up from so we click here you just copy the code over from here so Ctrl C to copy so we go back so we click on this so once we click on this now here it says the first background here is gonna be this not white which is contributor paste it in this is what we have now it's looking a little bit awkward right so we need one more background and the background should be the background we have this before the cards laid on top let's go get him I think I'm talking about this color right here and if you look at this color right here is what we have right for this particular Edge can you see this edge here so let's just pick this color over from here so you have everything you can use it where you like so now here we go we go ahead and Ctrl a Ctrl C to copy all right so we go over to power bi so the next one now is this particular alternate background here so we click this I'll paste this in so we have something like this okay let's go over to our our grades grid grid here and let's change this to something like this how about this this look good right so now it is time for me to play with the value area on the value we don't want black so I'm going to use white so another alternate text here I'm going to use this color here so you can see this is exactly how we got the one you've seen previously before now created so the next thing we have to actually touch right now I think it's gonna be uh the header right so let's start the header and see go to the header and here we have um where it is where it is this is the text it text should be on White Plain White and for the background we want to use this dark one so we have this can you see that beautiful so now this is exactly what we have done so I want to keep a space between this particular head right here what I can do now is just for me to move this down a little bit just small so perfectly done so we have something like this okay guys what is left we need to actually create our what I call it a title for this Fleet Management dashboard so let's do that I'm going to click over to this particular text box right here so I can stretch it up move it up to this level so inside it I'm going to type in something like this so Ctrl a to actually select and change the content inside it so let's do 26 and see what we have on 26 okay nicely done so right here I'm gonna put this on white let's do white not very yeah and this one we have to change it to different color so come here we paste in this color uh the last one here should be on different color as well let's click on this and let's do um I'm gonna do this color yeah it's very color here so for now the next I'm gonna do is to actually make sure I have it on a bold font only the Bold font for all of them so go ahead and Ctrl a then click right here and choose this particular let's go down a little bit um what color is that yeah what font is that this one here should be okay so once we have done this you can just reduce this a little bit so come over to size and style and ton of this and we should have something as beautiful as this so nicely done can you see this right now so we have almost created what you have seen previously before now but we are not done yet let's do the needful to have the other part of it created that is the most fun part where we write our Dax so I'm talking about this part if I hover over here now what do you see we have the total drive of course we've done that so the average speed the average fuel efficiency the total fuel consumption per kilometer and fuel cost per kilometer now how do we create this tooltip let's do it okay heading back right here within the measure so now I would love to create a different merge for my toolbit you know that so just we click click on modeling and we come right here to create a new table don't forget what we've done to do this so we want to store all the measures we're going to use for this tooltip inside a particular table that is what we want so right here I'm going to type in tooltip tool tip measure measures measures measures okay put an equal sign here the color bracket anything should be into it so you close it and your heater Enter key that should definitely give you a total measure so we save all the mergers we're going to be creating for our two tip right in here okay now we have this created let's go ahead and open it up and right click to create our first measure so let's call this measure driver AVG for average speed so to do that now what we have to do is to use the divide function so we're going to say divide so divide what we're going to divide our total travel yeah total travel so bring all the measures created by hitting the square bracket it will give you the list of all the measures you've created so total traveled we divide that by our total Drive can you see that now so with this now we have just created the average speed for all our drivers you know so that is the first measure we need to create we get it so now we can definitely use the comma separator and I will use just two decimal place to do this very important don't forget so it's actually a default on it so the next thing we create under measure so this time around we're gonna create the measure for average fuel efficiency yes so I'm gonna do if video every year so it's going to be average well if Vision yeah something like yeah efficiency so equals so what we do in this particular case right here is very very simple so we do the same divide function we divide shift enter [Music] um we're dividing the kilometer traveled that is kilometer traveled so we do that by totaliters so totalities use um letters consumed so this will definitely give us the average fuel efficiency so this is exactly what it is so the next thing now is to create a new measure again so this one will be total well total let me do copper case total fuel consumption per kilometer so what you do now is gonna be very simple either divide function so we do delete us the letters so it has consumed we divide that by what by the total travel kilometer traveled that is a window yeah sure so do your formatting nicely very important so remember we have to actually format this into a currency because it's talking about total fuel consumption per kilometer it's talking about the value not latest consumed right so that is exactly what it is once you have done this you go ahead and actually make sure you create a new measure for the next one and the next one is going to be well cost per kilometer um sorry uh we're gonna have to reverse this some let me just quickly solve that problem here this is not in value this is not in value let's do that so this very one here I'm talking about a total fuel consumption here so total fuel consumption per kilometer uh is quantity the quantity the physical fuel consumption in terms of liters or gallons per kilometer traveled that is what it is so it's not actually in value in in like in dollar or money spent whatsoever so we just don't want to use currency for this so we can use number just use um use number let's use decimal for example decimal is going to be two decimal places that'll be fine so the correction has been made so we go ahead and create a new version now so right now we're going to create a fuel cost per kilometer so the fuel cost per kilometer now focuses on the monotreme expenses of wealth consumption you get it so now here we go foreign [Music] part of it so we still use the divide function divide function here and the next thing we do is for we to use the total fluid consumed um here I would go so we want to divide that by what we divide that by the by kilometer traveled by kilometer traveled here we have the kilometer traveled shift enter so this is the one you can actually format as a currency not the previous one so we've actually corrected that hope you noticed that so once this one has been done let's go ahead and do this particular dollar sign number formatting for it so don't take up the extra decimal place because some of those value might not be up to even a dollar per kilometer so we want to see how many how much Cent it is so once you have done this we have just created exactly what we want so we just want to go ahead and let's rename this one to driver I'm going to do driver dashboards see how we go so now we create this one and we want to call this one toolted driver [Music] tool tip see here we go so it is time for me to start quick not tooltip right now very very important so let us insert go here come here and for tooltip click here and I will choose this tooltip that is beautiful so we go over here the canvas settings so here we use custom this is where we have to do something different let's make the height 350 like 350 so we do that by what do that by 260. so we can decide to actually say from Top when I put it in the middle and it's exactly what we have so the very first thing we want is the name of the driver we're going to be selecting when we hover over it we want the name of the driver being hovered on to show so let's go ahead and use this so once we have this here let's do this resize this and resize this as well to do this now let's go here and we go to a driver table so here we have it so click on the driver so we have this so we have to reduce the size of this driver go back here and uh let's I think for the color we want to change the color so open this place up for this particular background right here that's what we want to change open it up and let's do a change of color so we click here I will go with this so once we do that um think yeah that should be something cool so we go over to um here we do 25 to 5 that is beautiful the next thing now is the turn is off and I would like to use white here I think that will pop out very well this is beautiful so the next thing now is for we to actually make this like this so nicely done so what tells we need we need to get a total driver so to get a total driving right now let's go ahead and insert this one again so we come over here we're going to the first measure not the tooltip measure right now so here's the title measure so the measured table will get a total driver in here so I love it so there is one thing I would have loved about this God is simple card but I think the cutbacks card to use here is not as is the new car that you know probably I just introduced the new kpi card we just introduced that one would definitely give me control over my title whatever it is so let's go here and let us choose this very card right here put in this new card so we have that I love the way it is right so we have to work around this is too big let's put the card let's go to call out let's put it on 20. exactly so we'll reduce this to something like this so the next step now is for you to go to ship here I think no we go to card we scroll down the field no fill and no border so we want something very flat so before we do another thing let us change this particular place so we want to change the background here I'll go over to my canvas settings no no the background here I'll click over this place I want to choose something like this so I'm going to put this on zero percent that gives me this so now we need to take off the background here we scroll scroll screw like div we have that here we go we turn off the background as well so once we have done that the next thing we have to do right now is just to go to the um let's navigate call out so the color for a text should be this color here that pops so we go for so let's scroll down and go to the label so from the label we change the color of the label to something that we can read and this is exactly what it is so once we have gotten this right so let's just put it to the top here something like this push it a little bit so create a space here so all we have to do now is just to control C and uh paste it that will move this down so we just change this one here so what we want here is the average speed so we go over here click here so this time around we don't want this we want to get from Auto tip so we get the average speed so here we have it so we paste a new one so move this one here so on this one what we need to get is actually the fuel consumption per kilometer so click here to tough well consumption by kilometer so here we go we have this uh I think we might want to have to reduce this oh it's a bit much so we paste the new one so the last one here just bring this down I think this should have been the last one here should be our fuel cost per kilometer so click here no this this here well cost per kilometer so now we just need to format this it's now looking in some kind of very cool so we should have done that from the Inception I thought it was fine so just put two decimal place here then hit your Enter key that should actually correct it right now it's nicely done so now we need to get to paste last one paste this here so we drag this down so the last one should actually be our average full efficiency we've gotten that done which have we not done here so that is going to be so our average speed is left so we just want to go ahead and pick up the average speed so make sure you click on this very one here click here and let's go for our average speed here we go for our average speed so we bring in our average speed Drive average speed here that is beautiful so now let's do this um I'm gonna go ahead and move this up a little bit so we have to just maintain the space so here we go nicely done so I'm gonna have to highlight everything I have in here exclude this top one so all I'm gonna do now is to come back here and let's go down for this label here so let's reduce this to like yeah sure this is cool it shows everything I want so once you have very once you're very much sauteated we can reduce oh yeah we have reduced everything we want I'm gonna go ahead and go to insert here foreign get this reduce this so bring it up here take it all the way down so let's come here for the Border no for the fill click here I want to use something like this color here just to show something right here I might see something much more bloody okay I think I prefer this I love this so one more thing go over here system around click on this so reduce this bring it here give a space a little bit just do this and we just reduce this something like this we're fine so we have to change the color to this color then let's go for the Border we don't want no border for it once you have done this go to home you can click on copy and paste then move what you have pasted and just make sure you create a bridge for this to separate oh the this this friends between these numbers and get a one so this is exactly what you do I can just highlight everything like click on this so we have the some kind of click click click click here so we can move them let's see oh I think they have to be moved individually no problem just give it some time to some kind of do this it's gonna pay off because you are doing yourself a lot of good work to have something that's turned out properly let's do a take time to do this the last one ship it is one here so one thing is left oh is there anything so I think we can just make do it what we have right now so we are done with this very you know formatting so it is time for me to get this to our you know let's see let's see let's see let me see here click here let's see what is giving us this kind of driver ID in driver no we made a mistake here I'm so sorry so we don't have to do this in driver because we should have some kind of you know have modern discounts we are counting to that drive not to that driver total drives you got it so let me put s here to correct this total drives here and we come over here instead of us doing this count over the driver table we do this count over the uh F let me just put driver so once we have our driver ID you can see we have the one in driver table and we have this one in the fact table driver kilometer traveled so this is what we need to count so if I hit my enter right now we should have like 189 I presume let's see that so 189 and this doesn't only correct the drives it corrects other values where we use it so to kind of make some kind of division so do you see this right now so make sure you make some kind of verification to see what exactly you're calculating that is exactly what it is that will save you from having wrong calculations so let's go over to our driver dashboard so here we are so it is time for me to actually get what we have some kind of audio that is toe tip inside here so click on this and go over to here so from there you click on properties from properties you see this particular tooltip right here go ahead and turn it on then click over here and now it is time for you to actually go ahead and click on this particular page here and change it to driver tooltip so let's find out what we have if I hover over this right now let's see what information we have so total drive is 13 and the average fuel efficiency is 14 or 4.11 total fuel consumption per kilometer I told you this has nothing to do with value but how many gallons uh whatever the measurements being used per kilometer the free consumption is actually 83 dollars per kilometer and Driver average speed is 5.28 okay so can you see it right now per kilometer everything is down this is exactly what our client is looking for and we have just gotten that done but one more thing our table is looking some kind of flat so before I get this particular table fixed I want to remove the tooltip temporarily for now let's go over here so so where is that we click on the table uh we click over the properties and uh we turn off the tooltip for now so if I hover over it I don't see nothing so what do we do now we need to actually make our tool um our table to look very beautiful and I already have you know some colors in place for this let's get it so this is one of the colors we're going to use for our table to look to make our table look very nice so I'm just just going to go ahead and do a copy so go here Ctrl a Ctrl C to copy so we step off so now we're back here the very first thing I have to do is just to scroll all the way down once I'm here go to visual click go down so when you are down first of all look at this particular one where it says specific column so click on that and scroll down so we are in driver so click and go to kilometer travel so I want to make sure I align this one to the left hand corner so do that to every single columns and let's see what we have foreign so finally we do it to fix costs and that is exactly what it is so once you have done that we scroll all the way down and now we see where it says cell elements so this is exactly what it is so from driver we choose the first one and what we want to use is actually data bars let's go ahead and activate it so we have this very cool though but we don't like it so let's go ahead and change what we have as a bar color do this and more so here we go if I click on OK that for them to like give me something like this so the same color we have over [Music] here is what we want to have for this how do we get it clicking on this now will definitely retrieve the color for us so go ahead and copy and we click back on our table so once we've done that we scroll all the way down then we are here we select the next one that is going to be our consumed letters so we turn on the bar so click on this let's do this okay click on OK so we have something oh no this is not really cool what do we do so let's some kind of find this color and see if this color is going to actually solve our problem so we want something very cool we don't want something too shiny so we click back here we scroll the way down then this is it here so paste this in here let's just take a look at that so this looks very cool so I love this and this would definitely be for my maintenance cost let's go for my maintenance costs I'm gonna go for [Music] maintenance Cuts here turn on the bar click click here click here and we have this okay okay we have this right so the same color we have which is this particular color we have right this is what we're going to use for the rest so just go ahead and click on this click here and copy then just cancel it and now we select if well consumed so we turn on the bar we click on this we just change that to this very one here so finally we select the last one which is the fixed cost and that is going to be this one this one here this here click on this then this country to paste then we click on OK if you look at this is looking much more cool than the previous one and this is exactly what it is to create a very nice looking dashboard you need to spend a lot of time trying to do you know some kind of adjustment shifting and stuff like that before you could be able to get exactly what you want so you we have one more thing if you look at the introductory part of this particular tutorial we talk about adding some couple of slices let me show you what I'm talking about okay we are right here this is the tall tip of the former one go to driver so if you look at this if I actually hold my Ctrl key and open filter that opens this particular place for me so what do we do to have something like this and if I choose any of my drop type my dashboard get filtered immediately and the drivers on that particular truck type would be shown up and the trailer type will show me which relies it and if I just go ahead and actually click on close we can close this and we are still maintaining the same filter how do we create something like this so let's see that so go up to this particular part here insert and click on ship and get this particular shape so now here we have it let's go to the size click on size here uh size and position let's go with 32 [Music] 32 year let's do it by two five eight something like this so we can now move this over to this spot so because the color should be changed see here we have it so once we have it in now the next thing is to choose the color that we're going to use for this if I click on this I can have my color from here because I've used the same color right here so what do we do to get a color so we go all the way to where we have our value right in so so so so so the value here and we have alternate color I think that should be this particular color right here let's see if we have it so now let's go ahead and copy this very color and now we can step into this place then we click on the fill oh I think we already have the color right here I think I think so this color yeah this actual color is the exact color we're going to use the Border should be turned off and we have the color so inside this color here so what I'm going to do right now is to actually open the text click here and I'm gonna click here and say uh open filter so open filter so my open field test should be a little bit you know bold or should I use a bold font let's try that so if I use this this look quite well I can fix it back to open filter on 10. this is beautiful so once I've gotten this but I'm not really started with the color I have let's see if we can have a definite a different color like try this color no but let's do something different let's try this color okay I think this color pops the way it should be I love this color so we have this first color right here and I'm gonna have this one copied and paste somewhere copied and paste so over here this one should be changed to something different let's go to the text so let us just choose this one to be close so close so we come here and choose this so all we do now is to reduce the transparency to something like this so just let this be right here so let's go back to insert from insert I click on this I collect this so now I'm gonna go to this size let's do three three ninety so let's do that by uh 269 but the Covenant is some kind of too much right let's fix it so we go over to um where could I be shipping Style let's reduce this [Music] something like this is cool so here we go we're gonna have this right here so when we open it this is where we want it to come so now we change the color so we use the same color for it so this one right here is going to come come over to this part okay so when I click on this one I don't want to have a background for it so it border around it so now we have this so the next thing now is um this one here I click on it I have it about this one don't worry we can rearrange it later I want to make sure we go to formats and bring this one to front so bring forward if you don't just bring forward you can use bring to front header over to them that'll give you the same thing so if I step off right now I should still be saying it exactly if I click on this it can disappear but once I step off I should be saying it so now it is time for a way to add our slices so the first thing to do now is to go ahead and add these slices how do we do that let's go ahead and click on slider first so we have the slider here so we can go ahead and grab the slicer we want to actually add let's go to vehicle and we click on truck type here so here's our truck type so quickly with the drop type being selected let's go to um the header should be turned off Slide the settings we go here we select tile so we have this and when I have it like this something like this would be cool so I can move it up to this level so bring it down a little bit okay so once you have done this go to format and Ada bring to front or bring forward so now we have to quickly go over to this a ton of the background what I want it so the next thing to do now is to go to Value here and the background from value should be changed click on this and let's select this one so once we have done that uh we can make the font to be much more darker let's select the same font as the background color so we can click on Bold that is it so the font pops out very well so the next thing we're going to do right now is to go to home copy and have this pasted so once you have done that we move this over here so now we have to strike this because it takes small larger or longer label rather so we click on this so trailer type this one now this time around is going to be truck type so here we go something like this so I just want to go back to my format and I click on bring forward so I love the space between them is nice if I step off I still have them visible so I can definitely click on this very first one now and some kind of adjusted to make it look as big as this select this select this one select this very one here so once you have done that let us right click and see where it says group so click on group so group them together they have been grouped now so here we go so they are now grouped as one but one thing is left and it should have added that before I do this that is going to be my title right let's go over and add it I think we still have some Works to do right here don't forget about that so we're gonna keep that for the last so what I'm gonna do right now is to go to my text box click on it and here I'm going to type in trailer type so here we go Ctrl a so we have to pop this a little bit so let's select a vodafones both phones here so if let's do like a 12 yeah maybe this is good this is good so oh why is this um let's do this let's move it over here so let's go ahead and turn off the background and now we can go here select it we do Ctrl a double click on this so we select something like this so we can we'll Ctrl C paste so we move this right in here so this one is going to be I think let's select this to understand what we are doing select this one once you double click you can select this so here is your truck type so it's going to be our truck type here so here's our truck type all we just have to change is this one to track it's a truck type so we can bring this all the way down here so let's align this to the middle spend some time doing this place so you will definitely like what you have done after all okay let's say we are cool with this so we select this as well we select all of this okay so we can do this to highlight every single thing we have in here we can just multi select all of them at the same time or what so once you have done this we just right click and make sure we grouped everything all the content inside it don't know why it's not working for me okay uh first of all let's select this and they can go ahead and select this one so I can right click group ungroup now I can just select this select this one then select this one select the the main content inside it so we can right click and now we can group all of them together so they have been grouped so they can be moved at once now so we can move them all at once so we can sit with them right here that is beautiful so it is time for me to actually make sure we show and hide this particular slicer so what we do next we come over to view and we make sure we turn on our watch or if you don't want to use view you can use here can you see this plus it depends on your version so click on this plus here and on the plus you can see where it says select selection and you check where it says bookmark you turn on the bookmark as well so you can actually switch between this and this so the very first thing I'm going to do right now is to click on this so once I identify that it's a group I can actually click on it and I'm going to type here I can just say slicer sliders slices right so here my slider is active is on selection I'll go over to bookmark here what I'm going to do now is just to click on ADD double click on it to actually change the name I'm gonna say show underscore slicer sliders so now the next thing is for we to actually click here so this particular dots once you click on it you have this so deactivate the data so click back on it so you deactivate this particular current page so click back on it again you actually deactivate this particular all visual so once you lastly click back on it you click on update you get that so now once you are done go over to selection again now it's time to turn it off it's been turned off make sure you have it selected if it's selected like this that is good go over here and click on that one double click and here you type hide underscore slicer so now we can just go ahead and do the same thing now we've done they touch a bit unchecked so we go for current page uncheck it don't mark it so we go for all visual do the same thing so we click here yeah is this you click on update so if I click on this oh I think what is going on we might have done something wrong here let's see how to correct that so I'm so sorry for that let me just go ahead and have this one deleted for now we're gonna do it for the last time so click on this and uh do this so let's do this again for the last time so what we can do now is to make sure we have this selected um that is the slicer here this letter selected if you mistakly select something different that is when you see what you have done wouldn't work so now we have the slides are selected we go over here we click on this and we double click and we say show show underscore slicer slices so here to enter key so we come over here we deactivated data so we do the same thing and we deactivate this particular current page so lastly we deactivate this particular all visuals so once we click what we should have activated now is this one checked this one checked as well we update so let's go back here now we turn it off make sure we select slices we go all the way back here we click on this double click we go ahead and click on hide underscore slider once I hit my Enter key I do the same thing right here the next one now should be this one and lastly should be this one then finally we click on updates let's test it out and see so if I click on my shows laser I should have this click on this it should be hidden click on this it should be back so if it is working if I select for example this chapter here it should have my dashboard some kind of you know filtered and if I actually go ahead and have this hidden it should keep exactly the way the dashboard is being filled that if it doesn't keep it just know that you have done something wrong so here we go we bring it back and we make sure we unfilter it by clicking on the Sim tractor it will definitely unfill diet so now we are done from here we can definitely have this one closed so we have this one closed as well we don't need it so we can definitely close this one so when we need it again we click on the plus sign so the next thing now is to double click on this one double click on it so scroll all the way down until you find action turn on the action then scroll down open it and scroll down then we are using bookmark so that is going to be our open slider then we select this show slider for it then for this one double click on it until you have the action opened so the same action has been opened for you turn it on then go over here and select bookmark then scroll down a little bit click here and this one should be hide so remember we are not on power bi service or right here on power bi desktop we have to click on our control key and click on close and that closes this for us when we hear the contract again and click on this it will definitely have this open this is exactly how I have done what you have seen in the completed one so now the next thing is giving us uh given the title to this one right here very important right so let's quickly go to insert here on the text box on my text box here we're going to type in totally Tire consume so DotA okay liters consumed [Music] so we quickly just some kind of put it on 12. then we do this just make it a bit smaller let's centralize it come over here do this and we just make it this way so once you are done all you have to do is to some kind of a copy so we did copy something wrongly remove it so click on this one and make sure you copy it just copy and paste it so I'm going to show you what you're going to do now so play this one right here in case you forgot what this is what this one is just click on it and click here so it's going to show you total drive so all you have to do right here is to remove this particular part remove these parts and I represent it with Drive just go ahead and do this so you paste the new one and move it to this level so this one here is total kilometer total kilometer traveled km traveled so you can just paste the next one here and drag it all the way down so here is going to be on top you can see we have most pins on top so what we're going to have right here is total fixed costs if you don't get it just click on this and click here so fixed costs so leave the total and just highlight the menu one just type in fix costs then all we do is to do this so we just bring this all the way here so this one should actually be our for consumed so all I just need to change is this part here so total well consumed adjust this and lastly we pay this one we should be done by now and this one is going to be like I can't remember this I'm gonna click on this click here okay that is total maintenance cost so here all I just want to have is gonna be maintenance costs right so I'm gonna remove my total so to create something a little bit short that will contain my box so what about this okay guys if you look at this it's exactly what it is that we have let us compare this to the previous one we have created that I've shown you from the Inception of the class and let us see if this actually look like that one but before then let me adjust this I'm gonna click on this one here the three dots we resize it to this place okay we have something like this I'm gonna show you and you're gonna tell me what is the difference between the previous one I've created before we started creating this one from the scratch and let me know what you feel in the comment section let's look at that so we have this one here remember we have driver analysis that is what separate them so can you see it right here right now we go to the next one that is this one we do that again we switch to this one now we switch to this one can you see we create the exact thing I have created before now not much difference so this is exactly what it is if you think it's worthy of saying thank you leave a comment and say thank you and always give you thumbs up the days share to your friends and let's see what will be the next one to be posted on this channel thanks for watching foreign

Channel: Data with Decision

Views: 18,299

Keywords: data with decision, excel dashboard in nigeria, data analyst in nigeria, excel in nigeria, Power BI Fleet Management Tutorial, Power BI Dashboard Creation, Fleet Management Analytics in Power BI: From Data to Insights, How to, How to create dashboard, microsoft power bi, copilot, fabric, AI in power bi

Id: JrjOiJtiPH4

Length: 116min 13sec (6973 seconds)

Published: Sun Jul 23 2023