KPI dual de Power BI
YouTube transcript, YouTube translate
A quick preview of the first subtitles so you know what the video covers.
hello everyone in this video we will learn about the dwell kpi visual I thought about the scenarios where I could use this Visual and I thought that maybe for a stock broker who's trying to evaluate the returns for a stock versus the gross index returns it might be useful so what I did was I grabbed the data for the Dow Jones uh index and I grabbed the data for Burkshire haway which is the company owned by waren Buffett just to see the kind of returns they were giving and I've got this here so you can see that overall Burkshire has given a return of 1383 0.4 which is incredible compared to Dow Jones which is just 15 28% so let us learn how to build this I've for this I've grabbed the data one is from Yahoo so I've grabbed the data from uh Yahoo and uh so I'll put the links on and I've grabbed the monthly data plus I've grabbed the D kpi visual I will be putting the links as well as the data files I'm using for this visual so let's continue let's just create another page and I've already imported the visual So and I've got bshar haway data and DOW Jones data with me so you can go here and we can see so this is the data for birkshire and this is the data for Dow Jones index so let's go back here and let's select the date from the Dow Jones index so we will just select the date here and put it as an access field and I want uh Dow Jones index to be uh at the top so I'll just drag this field into the Top Value and bshar close so close is the value at which the share or the index closed on a particular I just want a minimum value I don't want