Display KPIs & Targets in Dial Gauge and Default Gauge Visual in Power BI

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
[Music] hi everyone welcome to geek recorders youtube channel today i am going to show you how to show this type of kpis in power bi gauge visualization so in here i have used two gauge visualization so in my tutorial i will compare and show you how we can use uh this two-gauge visualization in power bi so if you are visiting my channel for the first time please subscribe to my channel for more power bi videos so let's go to the tutorial and see how we can achieve or how we can develop this type of to uh gauge visualization and the advantages of it usually in an organization they give minimum target target and stretch target so in my tutorial today i will going to show you how we can use gauge visualization to show all these three values in power bi dashboard so let's go to the power bi and see how we can develop this right so now i'm in the power bi my data set contains sales person item sales value and sales date so basically kpis will be defined for the sales value so uh this is my data source and you can download this data source in the description section if you want to practice this tutorial so let's see uh and let's go to the power bi dashboard and develop this right first we see how we can use normal gauge visualization to display the kpis so for that you can go here and you can add the gauge visualization in here by clicking it so it will display like this so there are some fields that we need to add here in the field section so we'll see how we can add some values in it right so now i'm going to add the values to the gauge visualization so then usually my value should be sales value that should be sum okay that is fine so here you can see some value is started to display now i need to change these values so there are a few methods that we can do that first thing is so you can go here and the gauge axis so you if you select gauge axis and you can set the minimum so my minimum value was 25 000 and the maximum value was 75 000 maximum target and my target was 60 000 right so those are the three values so this is the one method of the adding a gauge visualization the default gauge visualization so as you can see it is very easy so it is just only the matter of defining these values right so that is the first method right so the second method is without defining the gauge axis values so we can define minimum maximum target values as the fields so here we can define that for that we have to create few measurements so let's see how we can create these measurements so in here i want to add few measurement to this so first that i'm going to go and click new measurement so then i add minimum target so these are all our fixed values so i defined it as 25000 right so then again i have to go and add a new measurement so then i define the target as 50 60 000. and then i have to again go and create a new measurement which i define the stress target or the maximum target as 000 right so my new measurements are added here i go to here and i remove these gauge values first right then i come back to my field section i add these measurements to that minimum target minimum value and then i add a stretch target it's the maximum value then as the target i'll give the target value right so as you can see now we can get the same type of output by using these measurements as well so now let's go and see how we can add the next gauge visualization in order to display the minimum maximum and target kpis right so my next gauge visualization should looks like this so as you can see there are more uh details in that so let's see how we can uh add it to the power bi which the report that i have uh developed right so that visualization we can't find here because of that we have to go by clicking this three dots to marketplace so we'll click that right now i search the gauge visualization that i want right here i want the dial gauge visualization first thing is i add it to my power bi visualization pane so since i have already added it so it mentioned that you want to update it so i'll say yes right so now it is successfully added to my power bi visualization pane so next step is let's see how we can use this in order to display my kpis right so now we add the dial gauge visualization to my power bi dashboard right so uh as you can see here in the field section if you select dial gauge visualization there are more configuration than the gauge visualization right so we have to set main max targets target and actual start actual end point value so different fields are there the first thing is that i add is uh the point value so that would be the sum of sales value so that is i have added so as you can see now the minimum value shows as 0 is 100 right so then this is the point value so now the first step is to change the maximum value so i go here and i will add the maximum value as the stretch target right so as you can see now the point is correctly set to the 73 000 location so now uh in this gauge visualization i want to add few separation that mean i want to separate minimum target level target level and the stress target level so how we can do that so if we select this one so minimum value is already set to zero so i'll keep it as it is and then uh target start so target start value i'll set it as target right so now as you can see the 60 separation also uh came into my visualization so here the value shows as 60 right target ends that i don't want because target ends it's always 75 000 the stretch target and actual start i will set this actual start as the minimum target right so now guys as you can see all the three separations are there 0 to 25 000 there's no any target achieved 25 000 to 60 000 it is in the minimum target level sixty thousand to seventy five thousand it is in the target level so if you uh the point goes above that then it will be the 75 000 that means the stage target achieved right and we can do few formatting here if we go so we can change the font size and then we can set this custom colors to this visualization right and also we can set formatting and we can start toggle and we can remove this so as you can see now uh kind of different values are displaying different value in the sense it is displaying 73k not the actual values right and also we can change the title right so we can say kpis 2020 right so uh we can change the font size as well background color i'll set it as black so as you can see now the desired output that we have gained by using this dial gauge visualization there are a few differences here so when it comes to gauge visualization so as you can see it started from 25 000 because in gauge visualization we can't have separations like this i mean the dial gauge visualization we can have this value separations so that is the one major difference when come to gauge and dial gauge visualization and when come to tv screen so dial gauge visualization shows a kind of better view so i recommend that you use it and also depends on your requirement you can configure this a lot so that also one of the advantages by using the dial gauge visualization and i think you have learned to use how to use this gauge visualization and the dial gauge visualization to your power bi dashboard and thank you very much for watching my video and please subscribe to my channel for more power bi videos and keep in touch
Info
Channel: Geek Decoders - Power BI Learning
Views: 26,231
Rating: undefined out of 5
Keywords: Learn Power BI, Power BI for Beginners, Power BI Latest News
Id: UfVSy9bC4UQ
Channel Id: undefined
Length: 10min 5sec (605 seconds)
Published: Sat Jul 25 2020
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.