Power BI | Advanced Bar Chart | Custom Bar Chart | Power BI Tutorial #powerbi

hey guys welcome back to my channel so in today's video we are going to see Advanced custom bar chart in powerbi and in front of your screen you can see this is a bar chart which we are going to create and you can see it is customized bar chart or we can say Advanced bar chart which we actually have in our powerbi that gives us uh you know a normal bar chart where labels are broken uh we are not able to add multiple uh we can say other labelings or other numbers over there so in front of your screen you can see here uh we have created a bar chart with respect to sales and subcategory and here you can see we have adjusted the label above the bar chart and we have provided the sales number over here with respect to that also you can say in front of uh your screen that is at the end of this particular bar we have added few uh you know calculations or we can call them as uh current month and previous month calculation and with respect to your uh you know requirement you can add uh week wise you can add year-wise quarter wise whatever you want you have to just change the calculations you can see the upper Arrow it indicates that the sales are increasing with respect to last month and what is the percentage of increase and you know what is the difference between them right so with respect to last month and current month what is the difference between the sales right similarly if it is dropping if it is negative then you can see it has been dropping over here how much it has been dropped percentage wise and you know sales wise how much it has been dropped so likewise all the numbers we are getting over here and it is completely Dynamic you can add different filters over here with respect to which it will be operated right so in this way we are going to see this entire custom bar chart or we can say Advanced custom bar chart and so let's take a new sheet so I will take a new sheet for us uh where I will show you all the procedure and what calculations I have used so this is a new sheet for us in front of your screen you can see this so now what I will do is I will first connect to my data so the data which I'm going to use I will add this data in the uh description box that is link uh for this particular data you can download and you can use uh either way you can use your own data you can just follow the procedure which I'm using and you can use any other data as well right so I will just click on Excel file and I will go here and I will connect to my data that sales data okay so this is the data which I'm going to use and for that I will be using a orders table right so whatever table I will be using is the order table and I will just click on load the data right so it will load the data for us and first few uh procedures what we will do is I will create a date table or a calendar table so it is used if you are using a Time intelligence function because in this particular uh bar chart video we are going to create some mon to date calculations at previous month-to date calculation and those are required uh so if you are using those it is recommended by powerbi or Microsoft powerbi that you should use a date table for that so before moving ahead into our video let us discuss the important projects in data scientist field so these are some few realtime projects like covid-19 prediction credit card approval health insurance prediction Bank turn deposit customer churn housing price predictions and some other projects like lb data professional survey breakdown so you can just click on this and you can view the projects as well there are a few videos and introduction videos are available for this right so by using this kind of projects you will enhance your resume so all these projects you will get on one single platform that is nothing but on Odin school so this data science course from Odin school is a live instructor lead course and in this they will not only teach you the theoretical concept but you will also get Project based learnings they will take different mock in views and there is a dedicated job application portal as well the data science core syllabus include different core modules like SQL python they will also teach you different machine learning Concepts Eda generative Ai powerbi and some bonus modules as well like Advanced powerbi Dax functions snowflake then GPT Azure Advan Excel R and P Sparks as well so you can see many people have done career transition in this particular data science field whether they are from techn technical or a non-technical background so there are few success stories as well you can just click on this particular thing and you can see there are few different success stories as well of the different people you can read all of them so Odin school has 500 plus hiring organization partners and those are big Brands and after you complete this particular data science course they will help you in reaching out this particular Industries so there are different career services in the nutshell and in this you will not only learn technical but will also teach you communication and aptitude trainings they will take your different mock interviews so you will be ready for any realtime interviews as well they will help you in building your resume and other Professional Profile building as well they will take different workshop on your behavioral and workplace Behavior teaching as well so the mentors and speakers for this particular entire data science course are from reputed Industries who have large amount of experience in this field and variety of domains which they have worked on so the upcoming batch of this particular data science course is from 27th April and the next batch is from 25th May and the course fee of this particular course is 75,000 plus GST and you will get an early bird offer up to 10,000 rupees and you can reserve your seat by paying just 5,000 plus GST you will also get an Emi option of 3 month 6 month 9 month and 12 months as well so what are you waiting for just go ahead and book your seat I will add the entire link of this particular particular site in the description box of this video I will also pin into the comment section and you can just click on that you can come to this website and you can book your SE so let's move ahead with our video uh we will go in the table view okay so you can see this is the already data which has been uploaded and now here we will try to create a new table okay so here you have an option in table tools called as new table okay so just click on that and that table is nothing but date table so I will just increase the size for you so you can see it so name it as date table okay so this is a date table you can name anything and we will use a calendar functions to create it so calendar so start date will be the minimum of order date so order date is nothing but it is the date from orders table here you can see uh so in order date you can see we have an option here called as field called as order date so same field we are using here that is minimum of order date okay so you have an option or the date here called as order date okay comma okay second argument we will use that is end dat so it will be the maximum of order date okay so everything we are deriving from data itself so it will be date and we will take it as order date okay and we will close our bracket enter so you can see as soon as you do you will get a date table over here starting from this that is which is the minimum date in our data and all the dates in between the maximum date so you can see the maximum date is this one right so the same way we are going to find out and now what we have did uh we have created this date table but we have to connect it to our data right so that is nothing but we have to create a data model to give a connection or a relation between these two tables right so just go in model view okay and here you can see here you have order date and you have date so just drag this date on this order date so this connection would be created right so it might be a possibility that you have already created this and now we will just create our advance bar chart right so now just go in report View and here we will try to create our bar chart right so for that what we will do first we have to do few calculations right because we have to find out uh current month and previous month sales so that you can uh I just showed you you have to create this particular label on this right so to create this label we have to first find out current month sales and previous month sales right so for that we will do few calculations so I will just write first tax measure over here and I will click on new measure and I will name that measur I will just increase the size first we will find out total sales okay first I will find out entire sales of this particular uh we can say entire data which we have so it is nothing but sum of sales we have to take just sum of sales so sum of sales I have taken for which particular measure you have to find out the month to date and previous month to date for you it will be different if you working on different data if you're working on same data you will be using the same gal calculations right so just manipulation of calculation will be there otherwise other procedure will be remaining same right then what I will do now we will find out current month sales I will take another new measure and I will name it as current month sales right CM sales right so now always remember the last month which we have in our data is December 2022 right now which I am shooting this video it's 2024 I guess uh it's April so current month sales for us it means that the sales of that particular month which is the latest month in our date right not today's month the data the data which we have in that which is the last month so that we will represent as current month sales previous month sales is nothing but if it is December in our data then one month back uh that is nothing but November 2022 you can check with respect to your data it will be different with respect to my data the sales or we can say the month will be different right so we will be using a total abity function over here right to get current month sales expression is nothing but the total sales right so out of this total sales we have to find out the current month and date is nothing but the date which we created that is date table right so from this date table we have created the date simple this calculation which we are going to use so this is nothing but current month sales I will just hit okay so you can see current month sales has been created in the same way we will try to create previous month sales so I'll just right click over here and I will click on new measure and I will name it as previous month sales okay and for this uh what we will use we will use a calculate function first right then it will ask us first argument as expression right so expression for us is nothing but for which mejor right with respect to which measure you have to find out previous month sales so we will use the reference of current month sales right so we have already calculated current month sales we will use that reference and we will go one month back okay so we have to go one month back with respect to this sales so we have to go on P back so for that we will use date add function right so first we will use date add function so it is asking us for which date so date is nothing but our date table right so the date table which we have created then it is asking us number of intervals how many months you have to go back if you are going back it is nothing but you are going in negative uh direction that is backward so we will use 1 month back so we will use minus one comma and then interval so it is going we have to go one day back 1 month back one quarter back or one year back so we have to go one month so just click on month and you can see our calculation has been completed and just click on okay all right so in this way you can see our Uh current month and previous month has been calculated right so if you want to check it is very easy to check right so uh you can just take this particular card visual over here here and you can see uh current month sales and previous month sales right so these are our current month sales and previous month sales you can see current month sales has been dropped with respect to previous month right so it is there is almost a big difference between this uh uh more than like uh 20 25k whatever it is you can calculate it so right so you can see you can evaluate you can cross check also if you want you can create a matrix chart you can see whether these values are correct right so I'll just delete it for now now what we will do I will just close this we don't want this and now we will create a uh you know this calculation right so this trend we have to create so for that we are going to use a Dax function so for it I will I have already created a Dax uh you can just copy this Dax for you right so I will just copy it and I will create a new measure okay and I will paste it over here so I will just explain you what what we have created so in this one single Dex itself we have created a entire calculation for us so what we have done here is we have taken our first variable M the difference and we have taken so difference is nothing but it's current month sales minus previous month sales right first we want difference then we want month on month increase how much growth is been taken so this is a standard formula which we use that is current month sales minus previous month sales divided by the previous month sales right then we have created a sign okay so that is nothing but if it is positive or negative right so if if this month difference right so which we created if it is greater than zero then we it should show plus sign and if it is negative okay if it is negative it should show blank nothing should be shown then we want sign Trend again so that is nothing but going up and going down right so now you will see that uh how to how to add this over here so you have to press uh one second okay so what you have to do is you have to press Windows dot okay Windows plus dot function and here you have different options you will get here and you have to go in this particular thing right in symbols so uh you have to go scroll down and you have to find those symbols for you again I'm telling you Windows do function both the functions or we can say both the keys you have to press at the ones right so you'll get open this particular dialog and then you can find this particular uh you can say this particular icons for you right so once we have created these four variables then we will return it and we will we have concatenated all of these right so first I want sign Trend nothing but up or negative or positive that is nothing but upward or downward Direction then I have added and and a space between that then sign that is nothing but whether it is increasing or decreasing so if it is positive it will show plus if it is negative it should show blank right and format okay so month on month we have created a format function for this just to show in percentage format right so for that we have shown a form format function and right then for sign also we have created a format to create it into thousand so we have to divide it it by 1,000 and then we have to show it in key that is nothing but th000 then we have again added one more space and a text has been added that is nothing but versus LM so this is I have named this as uh sub kpi that is nothing but we have to uh it is a second label we have created so I have Nam this so just click on okay okay and now what we will do I will just show you how it will look so I'll just take this particular thing that is I will take a kpi and I will show you how it looks right so you can see once you click on this you can see it is been called in in entire one single kpi you can see all those information which we wrote in this particular text right so I will just delete it for now okay so just delete it for now so before moving ahead into the video let me also introduce you to my website where I have different data analyst material and projects available so in first you can see I have data analyst complete material where you can get the material on different tools like Excel data warehouse SQL powerbi table and python in this also you will get different realtime projects interview questions handwritten notes the entire powerb and all the tools syllabus is also mentioned with the links which are available for those particular videos okay so you can read the description deson before the purchase then you can see I have different power back projects 13 unique power back projects on different domain is also available then different table projects 15 different TBL projects are also available then specific tool material also if you want like for powerp you can see what are the notes that are mentioned what are the different topics you can see interview questions ebooks cheat sheets if it is various materials are available you just have to click over here you can read the entire description what is mentioned in that okay similarly I have it for w material SQL material is also there and if you want to connect with me one to one you can just uh select any of this particular session you can book the call and you can connect with me for the one to one meeting as well right so now let's move ahead with our video and now we have uh everything now we will start creating our bar chart right that is customized bar chart so for that what we have to do is you have to go in clustered bar chart okay not this normal bar chart uh we have to go in clustered bar chart so just select this cluster bar chart it will be created over here I will just increase its size okay just increase the size of this bar chart then what I have to take I have do it by subcategory okay on Y axis I will take subcategory and on x-axis I will take sales okay so with respect to sales we have created this but I have to only show 10 subcategories okay so for that I will add a filter over here you can see a subcategory is there just click over here then instead of basic I will click on Advanced filtering sorry not advanc top end filtering okay you want top 10 okay and on by what value okay by what value it is nothing but by sum of sales that is I will take sales and I will add over here you can see sum of sales and just click on apply filter you can see only top 10 sales have been shown over here right that is sub categories now I will close this filter and on this only now we have to work right so what we have to do here is we have to create one more calculation over here so for that I will just right click over here and I will click on new measure and I will click over here and I will name it as label holder okay okay it is it will be acting as our label holder so label holder is equal to zero nothing you have to do you have to just press it as equal to zero this is the only text you have to write right and now what I will do I will take this label holder and I will add it into xaxis on the second okay so just click over here and as soon as you do your bar chart will change right so you can see it has been changed so what what changes have been done what what because we have taken a clustered bar chart it has taken two measures in this entire bar chart first is this and second is what the zero value okay because it was a zero value we have given to this label holder it will not show any bar because it's a zero value right because we are starting from zero and it is zero itself so if you want to see the labels what you have to do select this bar chart and go in format Visual and you can see a data labels is there just turn on this okay so you can see on this chair we have the sales value right the one sales value first and the second is zero value that is nothing but our label holder all right so the same way we are going to make use of this and we are going to create our bar chart right so now what I will do I will take this label holder and I will add it above the sum of sales okay so what I will do take this label holder and I will add it at the above the sum of sales right so right so as soon as I do so label holder is at top and the sum of sales is at bottom so as soon as I do your bar chart will change okay so what change has been happened over here that everything the color has been changed first thing and uh for the other thing initially it was in descending order with some of sales that has been also replaced so now to make it again with respect to that is the maximum value should be at the top and the other will be in the descending order so what you have to do just go over here and then you have a sort AIS right so now sorting is done on label holder instead of label holder we will do it on sum up sales and it is already in descending so just click on sum up sales so you can see again we are getting our bars aligned so just color has been changed color we will change it later I will show you how to change it right so now select this chart go over here right so now we will do some formattings on this and then we will add add our bar holder right so first thing what we will do uh I will just uh so what I will do is I will just go in Grid lines and I will turn off all of the grid lines okay then I will go in y AIS okay I will turn off the values okay I will remove all the values from here okay so first the values were there that is nothing but the subcategories so I don't want to show it over here I want above the bar okay so I will just turn off those and I don't want title as well okay similarly for x-axis I will remove the title and I will remove the values as well right so now our bar chart is completely cleaned now what I want instead of zero over here I want the name of this particular that is nothing but chairs of that particular subcategory so now to add it over here we will have to create one more calculation okay so for that I will just write here right click over here new measure and I will name it as label for bar chart okay you can name anything so I will name it as label for bar chart and we will use a selected value uh we can say use a Dax function as selected value so whichever values is been selected that will be used okay and we'll name it as subcategory only okay just close it and click on okay okay so now select our chart go over here format visual then you have an option first we will turn off the Legends as well so turn off the Legends and go into data label so open this okay so now you have all series has been selected over here instead of all just select label holder that is nothing with the zero value select label holder go down go in values okay and now here you have an option called label holder so just click over here we have to change it okay we have to change it to label for bar so as soon as I click on this you can see the labels has been changed over here you can see these labels okay and you can format this okay so instead of say I will use your B bold and I will increase the font okay I will increase it to 12 right so you can see you can change it from here you have to select your label holder go in values and instead of this we have to select the tax we have created but in front of this you also want the value to be shown okay so now to do that we will change our Dex again created that is nothing but the label holder which we have created for this bar chart in in front of this we will add a concatenated function and I will add add and okay right and I will add in double ined commas I will add a pipe operator nothing but a separator in between these two and again I will add add function okay and I will add this particular label for here that is nothing but some op that is nothing but total sales right we have to show total sales just click on okay so you can see as soon as you do this you can see sales has been added over here but those are not formatted right so we are getting it in three decimal points and a long number we are getting so we will format that quickly and you can see we have to add space before this pipe operator and after the pipe operator as well so I'll just click on this pipe operator in between inverted commas I will add one space over here and I will add one space over here right so you can see space will be added over here now we have to format this okay so I will add a format function right so format function I've have added already okay so we have to format this I will add a comma How formatting should be done to this right so it double ined comma I will add at 0.0 K okay and I will format this right and I will close the bracket right and I'll just click on this and you can see K has been added one decimal point has been added but it should show what 33576 so for that we have to divide this total sales by 1,000 okay that is nothing but divided it by 1,000 so that we can show it in thousands right that is nothing but KY that it will add a decimal points after three that is after dividing by th right so I'll just click on okay and now you can see it has been correctly showing that sum of sales with respect to this particular chairs phone storage and all those right so now next thing what we have to do here is we have to change these labels as well right so the labels we have to show which we have just created by using a a longer deex which we just used that is nothing but the subses right so this particular tax right so now again the same procedure we have follow select this chart go over here then go to data labels okay so now instead of label holder now we have to choose sum of sales okay so instead of sum of sales go in values now select sum of sales go in values so instead of these values to be shown we will show something else right so what we will do we will show something else that is nothing but sub we will show this sub kpi which we have created you can see it has been created it has been now showing it over here right and so now we have to show its position inside this bar chart right so it depends upon you if you want to show at the end or inside the bar chart so instead of Auto I will show it at inside end okay so now it will show inside this end of this bar chart right and now you can change the font as well I will change the font as UI Bard and I will inrease the font as well so now it has been shown so for each bar you can see it has been showing whether it has been increasing or decreasing with respect to L right so we already saw at higher level it is already decreasing so most of them you will see that the sales have been decreasing with respect to last year getting or not so in this way now what we have to do is I just close this now what we have to do we have to change the color of this bars so when you click on this bars you can see you don't have any option to change the color of the bar over here but you have the series right so just click on series instead of choosing all just choose some of sales right so once you choose some of sales you have an options to change over here so just click on this and now you can change the color you want okay so you can choose any color from here whichever you want and you can choose that color for you and then then in this way guys we have created this bar chart right so this bar chart because it gives very much value in one single chart right so in one single chart you are getting what is the value of that particular bar anything else also you can add here you can add the profit also for that particular bar you can add one more Prof you can say a pipe operator and you can show your profit one more you can add show you can show quantities so in one single bar you can show multiple measures and multiple insights right similarly here also you can show multiple things instead of month you can show week wise quarter wise or anything else whatever customized you have to show you can show it over here this is just an example which I have shown you in this video right so what can be done right and you can also change sorry you can also change the title also so you have to just go in general from here you can change the title so just let let us show only sum of sales by subcategory right so so there are multiple options uh to do this so this is uh the customized bar chart which we can do Advanced bar chart which will increase the level of your visualization and uh you will be acting as a pro in your organization if you use this right if you're are a freser or learning this particular course also right so these kind of things you should know to impress your colleagues impress your boss and impress your clients as well right and you can Showcase in your project also as an portfolio project to you know which you uh upload publicly so other peoples can see and they will get impressed with this kind of visuals right so I hope you like this and uh so just go ahead and uh C click the like button uh provide some comments some feedbacks if you think that was this helpful if you want more custom charts if anything else can be done for this particular chart as well right you can also go ahead and uh you know share this with your friends who are learning in this particular field and there are multiple options to change few other options also in this particular B chart but I have just shown you the essential ones and so this looks very cool right so I will see you in the next video guys till then bye-bye

Channel: Data Tutorials

Views: 2,085

Keywords: power bi, power bi tutorial, power bi tutorial for beginners, power bi desktop, power bi dashboard, how to power bi, stacked bar chart power bi, power bi for beginners, power bi training, power bi tutorials, power bi bar chart, power bi column chart, power bi desktop tutorial, power bi dashboard tutorial, power bi report, power bi report design, animated bar chart race power bi, radial bar chart power bi, stacked bar chart in power bi, power bi stacked column chart

Id: 3ULKOXFbYnc

Length: 29min 33sec (1773 seconds)

Published: Tue Apr 23 2024