- 6/1/2025
Bank Loan Project in Power BI _ Full Dashboard Tutorial for Beginners
Category
📚
LearningTranscript
00:00Hello friends. Welcome back again to our channel Vista Academy. So friends, once again, we have a project about the finance loan project.
00:19Now, we will use Power BI, which will be a beginner friend, which will be useful for you. I have a lot of tools that you can use in a beginner's advanced level.
00:34Let's start our project. First of all, we have Power BI Open.
00:41Now, we have a interface with Power BI Open. So, we will get data.
00:49Now, we have a CSV file, which I will show you first.
00:53So, this is the file. Here we have a column.
00:57We have an ID, which is unique. Then, we have an application type, employee length.
01:03So, here we have employee length.
01:06So, here we have a live domain.
01:08Then we go to client data.
01:10Here we have a function.
01:12In the location, we need a row of data.
01:14That's how we move into a file.
01:16There we have autism.
01:18So, it has the name of a demo.
01:20So, that's how we have added data.
01:22When you have a code for the title.
01:24manufacturer, that's how we have to be executed.
01:27Then the name of the customer,
01:29we have a table.
01:31Now, in the name of the limite,
01:34Then there is home ownership, which will apply to the customer, which will apply to the customer, or the client, or the client, or the client.
01:45Then there is loan issue data, credit pool data, last payment data, and loan status.
01:51There are three types of loan status. Charge off, current fully paid.
01:55Charge off, which means that your loan is running.
01:59If you don't have a bank post, you don't have time to pay.
02:05Current means that your loan is ongoing and fully paid.
02:12Then there is next payment date, member date, purpose, which means that your loan is applied.
02:18Then there is rate.
02:21Then there is term, which means that your loan is applied.
02:25Then there is verification status.
02:28Verification status is not verified.
02:30Not verified, not verified.
02:32Source verified, you can see that you can see.
02:34If you can see your agent through,
02:37your applications are verified.
02:40Your income is included.
02:42Your score is included.
02:46Then there is annual income.
02:48DTI is your debit to income ratio.
02:50Your income ratio.
02:51Then there is the installment.
02:53Then there is interest rate.
02:54Loan amount.
02:55Total account.
02:57And total payment.
02:59The bank has received the payment.
03:01The bank has received the payment.
03:02This is the power BI.
03:04Then I will use the tax CSV file.
03:06Then I will use the tax CSV file.
03:08This is the finance loan.
03:10Then I will open it.
03:12You can see that you can see the file's CSV file.
03:14Here is the tax CSV file.
03:15We can see this file's file.
03:16Here is the file's login.
03:18Then you can see the file's article based on entire dataset.
03:21Okay.
03:22Then here we can see that you can see the next file as part.
03:24So that you can see the file.
03:26Here you can see that you can see the file.
03:27and here we load the file
03:31we will show you the file
03:33first, we will click on the data tag
03:37and see if you have a file load
03:39here we will load the file
03:41here we will show you the file
03:43here we will show you the data
03:47we will show you the data model
03:49more than two tables
03:51so we will show you the power vi
03:55the data model it is automatic
03:57automatically patched
03:59data modeling
04:01the power vi
04:03and fit app
04:05here we will show you
04:07here we will show you the file
04:09you can see
04:11we can see
04:13you can see
04:15now we will show you the file
04:17it is
04:19you know you have selected the file.
04:23You have selected the name.
04:26You can indicate the integer value
04:36and choose table view.
04:39and here you can choose table view
04:45ουςを付 DACAP、既に、とりあえず、データが変化されたらその Punctuがさらにいません。
04:491つに、このValueでデータを変化されたら、ショートが発表されていないように。
04:51CodeCodeCodeBaseInはいつないように、レンジを変えたら、
04:56そして、このValueでデータが変化されるが、
04:59このValueでデータを変化していないように、
05:03データが変化されたら、総変化されたら、
05:06そのValueでデータを変えたら、
05:08どちらのValueでデータを変化していきます。
05:10I will change the date and make a change in the form of date.
05:16Then see, I will change the date and payment date.
05:20You will change the date, so I will change the date.
05:23I will change the format here.
05:26Then, I will change the text.
05:29Click the option.
05:31Sort date.
05:34Okay.
05:39You can see our date.
05:43Date format.
05:45Payment date.
05:47Text format.
05:49Date format.
05:51You can see this.
05:53You can see this.
05:55You can see this.
05:57You can see this.
05:59So,
06:01You can see you can see this.
06:05This is the date format.
06:06Calendar.
06:08You can see this.
06:10Then, you can see this next payment date.
06:12This is text format.
06:14I change this date format.
06:16This is the date format.
06:18This is the date format.
06:20Since this is the symbol,
06:22So, we can see the details on the details so that we can change the details.
06:33I think this is the text format, so that we can change the details.
06:46yes
06:48I don't
06:50then this is the last thing you can see here
06:54everything is ok
06:56then this is the last thing you can see here
06:58friends
07:00here you can see
07:02the video is the same thing
07:04simple you can see
07:06drag and drop
07:08so we can see
07:10report form
07:12first we can see
07:14and here we can see
07:16shapes
07:18triangle shape
07:20and here we can see
07:22here we can see
07:24triangle shape
07:26then here we can see
07:28copy and paste
07:30copy and paste
07:32then here we can see
07:34then here
07:36our dashboard
07:38name
07:40ok friends
07:42we can see
07:44gape
07:46gape
07:48and here we can see
07:50here we can see
07:52here we can see
07:54here
07:56there you can see
07:58I am not gonna change to the color and your color.
08:01I see now the color as exact as exact or as exact.
08:03I can naked eye on the background, color, color.
08:05I can make the color change.
08:08I can make the color change here.
08:11I want to look for the color.
08:15I want to see here in the color.
08:18I want to change the color color.
08:20Then I can save the color name.
08:22In font format paint.
08:23Here is the font.
08:25I will select the font with the font.
08:27and the various types are here
08:30format is here ready
08:33then this is what we will do
08:35KPI is here
08:37we will do this
08:38first of all KPI
08:43first of all we will do
08:45total customer
08:47we will do this
08:49then we will do this
08:51only
08:53unique value
08:55we will do this
08:57total
08:59customers
09:01total applications
09:03total applications
09:05ok
09:09I think
09:11I will do this
09:13I will do this
09:17total applications
09:21I will do this
09:23and
09:25we will do this
09:27format
09:29format
09:31format
09:33if you can
09:35boot
09:37if you want to increase
09:39then
09:41then
09:43then
09:45if you want to do this
09:47then
09:49if you want to do this
09:51format
09:53then
09:55if you want to change
09:57then
09:59if you want to change
10:01then
10:03then
10:05then
10:07you can do this
10:09model
10:11and you can see
10:13what you can do
10:15then
10:17you can choose
10:19then
10:21what we will do
10:23and we will see that you choose the deep color orange border.
10:26When we built a color border we would choose a colorもう the color surrounded and so on the established environment.
10:31Then after the color of us choose a color 18s.
10:36So the color is �iler, the color of the color has changed the color couleur as shown.
10:42The color change is shown in this title.
10:48And now you may add atrane newer orange border border Here you go back to a color bênin.
10:51So you will have to keep this mode.
10:53Now you can do it in 15 or 15.
10:5715 seconds.
10:59And now you can do it.
11:01And you can do it.
11:03And you can do it.
11:05And you can do it.
11:07And you can do it.
11:13And then you can do it.
11:15And then you can do it.
11:17where we have all applications applied
11:20so we can put it in total application
11:23and first application
11:29application type and address
11:33total address
11:40total state
11:43we will enter all the data
11:46and then we will find out
11:47and then we can find out
11:48and we have total fifty states
11:52and then we will copy
11:56which we can press and control
11:58and we have the format
12:01and we can see
12:05here
12:07this type of service can be
12:09and we can select
12:11The others and all will be able to do it and facilitate the needsESSES.
12:29I will show you the best option.
12:35Friends can see you.
12:37Then you can control it.
12:39Control it.
12:41You can see format and align it.
12:45Distribute.
12:47Distribute and equivalent distribution.
12:49You can see total loan activation.
12:51You can see total loan amount.
12:53How much total loan amount?
12:55How much total total?
12:57Bank has total amount,
12:59total amount.
13:01If you want to add total loan amount,
13:03total loan amount
13:11This is the total loan amount.
13:13And second is the total payment,
13:17This will be total payment.
13:19This will bring total payment.
13:21So, here we get total payment
13:23This value of total payment
13:25Can I ask this movie change longer?
13:30Total Received
13:32Total Received Amount
13:40So here total received amount
13:46Then you have the first total received amount
13:48that you have to ask.
13:49So you have to ask for any amount
13:51So you have to ask for all this
13:53Now, this type exists, this box you can increase and decrease in this keyboard.
14:08Then, when you click on the button, you can select the control button.
14:13Then, the alignment button, the format, and the alignment button, you can distribute horizontally.
14:18here are our additional check-up
14:23here is the text box
14:27text box
14:30text box
14:35here is based on background
14:39background
14:44oh
14:48in case you don't have the description
14:561,10,J1,F is coming up here
14:581,10,J1,F is coming up here
15:00then it's the bottom line of the
15:01back loop for the second
15:06sorry, 2 seconds
15:09the information is that you can't
15:11back loop for the second
15:13back loop for somebody
15:16I will show you the best option to create your own value.
15:20Then, I will use the option to change your own value.
15:26Let me increase the value of the value of the value.
15:30And I will increase the value of the value of this value.
15:35Then, I will show you the option to create your own value.
15:43I will see you in the bank loan summary.
15:46Bank loan item here.
15:49I will see you in the bank loan summary.
15:52Okay.
15:53Now, the facts are perfect.
15:55Then, what do we do in this case?
15:57First of all, I will show you the charts.
16:01The charts will be my place.
16:03The charts will be my place.
16:05The states will be the total application.
16:08The total applications will be the type.
16:10I will use the stack column.
16:13I will use this.
16:15I will use the Y axis.
16:17And I will use this program.
16:19I will use the ID.
16:21I will add the same image and now I will use it.
16:24Address state.
16:26The top 5 states will be the most active application.
16:29Address state and the filter function is the other.
16:32You will use the basic filter and here in top end,
16:35Top End
16:37Here you have 5
16:39When you click the case button, please click the dried
16:56So friends, you can see the top 5 states by applications
17:04then, what you should do is checkup.
17:05then, what you would like to see in your行our.
17:08then, what you can see in your account?
17:11then, what can you say in your account ?
17:14This account will be shown in your account.
17:18Then, what we can see in our account,
17:21then what you're going to do in account ?
17:24Then again, I will show you the stack column chart.
17:29Then, I will show you the stack column chart.
17:35I will show you the total home ownership.
17:37So, this is the total home ownership.
17:39Again, I will drag it down and drag it down.
17:43Then, I will show you the application.
17:47So, I will show you the application.
17:54So, I will show you the application.
17:57So, I will show you the application.
18:02Then, I will show you the stack column.
18:06The stack column is the total purpose.
18:10The application is the application.
18:14Then, I will show you the school.
18:17I will show you the stack column here.
18:22And again, you can see the stack column here.
18:24And, I will show you the ID.
18:26In the y-axis, you can select the school.
18:29Drag it down.
18:30Then, count distinct.
18:31And, the purpose.
18:33To the purpose.
18:34We will show you the access of the admin.
18:36The purpose of the purpose.
18:37You can see the purpose of the application.
18:41I think this is our debit card, top 5 or top 6 or top 7 you can see, top 5 we apply again, top 5 we can see, count of ID, count of purpose
19:02here is our basic and filter, top 5 we can see, top 5 we can see, top 5 we can see, top 5 we can see, then again we can see, control and select the widget
19:28and you can see, in course format is the format
19:43So we have x-axis contact, bolder, and color-rise type here.
19:49Let's have this, we can increase the form and increase the y-axis value.
19:55Y-axis value, because we can change the value.
19:59Now, I am off-fail.
20:01Because I am on the data labels.
20:05I am on the data labels.
20:07Let's say I am going on here.
20:09Here you can see the data labels.
20:13Then you can see the values.
20:15You can change the x-axis value.
20:19I think here you can change the data labels.
20:23So value, you can change the values.
20:27Then you can change the values.
20:29So you can change the values.
20:31Then you can increase the same thing.
20:33Here you can change the same thing.
20:35Here I am going to make an easy way.
20:37There is a page and format pinter used to be used.
20:42Format pinter use don't have to use.
20:44Format pinter use is as you can see.
20:45Then there is a page when we set the format pinter.
20:48Then I will add a success click.
20:50Like this same format in the ersten надо.
20:52Then after the configuration change, I will add a change.
20:55So when we change my friends, we can change the effect.
20:58And it is a effect.
20:59I will show the mode and it is a dark.
21:01So you'll hit the add-up.
21:03Now we can see the transparency
21:07I think we need to change the current
21:10and make the transparency
21:13and then we can see the transparency
21:16now we can see the current type
21:18the current type of data is the current type
21:21when we have the current form
21:26we can see the current format
21:28here we can see the distribution data
21:32I will show you the values that I will show you
21:36First of all, we will show you the status.
21:40The status of the recording is the number of applications.
21:44Then, we will show you the value.
21:48We will show you the value.
21:56We will show you the value.
22:02Ctrl C Ctrl V
22:04and we will have a point of view
22:06and if you have a status
22:08then you will see
22:10and you will see
22:12which verification type
22:14and then you will see
22:16Ctrl C Ctrl V
22:18and here you will see
22:20which term
22:22which term
22:24and then you will see
22:26and then you will see
22:28Ctrl C Ctrl V
22:30here we will see
22:32distribution
22:34with the help of PyChart
22:36PyChart
22:38PyChart
22:40we will see
22:42PyCharts
22:44or DonateCharts
22:46or DonateCharts
22:48if you donateCharts
22:50then you will see
22:52if you donateCharts
22:54then you will see
22:56DonateCharts
22:58and then you will see
23:00popular
23:01this
23:02this
23:03is
23:04consumer
23:05but
23:06here we will see
23:07you will see
23:08here
23:09and
23:11which
23:12where we are
23:13we
23:14subscribe
23:16total payment
23:18we will see
23:20total payment
23:21we are
23:23First, you can see the verification status and the payment value for the verification status.
23:33You can see the verification status.
23:41This is the verification status.
23:47If I am going to click some link, click itique
23:50I will show you the link in the post which you will see
23:53gitu when the address is received
23:56which you will see the link in the post
24:03I will show you the link in the post
24:05You can see this link in the post
24:07So friends, you can format this as I told you,
24:22and then you can format it.
24:26Then you can click on the control button,
24:34and format page, and align here, distribute horizontally.
24:38Distribute horizontally, what do you want to do?
24:40The gap is equal to fill.
24:43But, you can see here, formatting,
24:45you can see the view tab,
24:48you can change the type,
24:51you can change the type.
24:53I think this is better.
24:55So, I will show you the background color.
25:00We can change the color,
25:03between the background color,
25:08and effect white color,
25:11I can change the background color,
25:13I think this color will be stable.
25:19Now, I want to write for the format Painter.
25:26This is the result in the format Painter.
25:28And again,
25:31Simples i see my Formit Painter and here
25:35Simples again Formit Painter and here
25:41And here
25:43And what do we do
25:44We do this again in view
25:46And you can choose this kind of color
25:49This type of color is also here
25:52And you can see this formating
25:54This is better than this
25:55So you can go here
25:57And you can choose this list and this list
25:59and I will add data values
26:05and just check that
26:08the data values are for all data levels
26:14I think I will add data levels
26:18with value, then I will add data values
26:23and I will add data levels
26:26and I will add data values
26:29thing
26:33yeah
26:35person ready
26:37then
26:39friends
26:41here
26:43duplicate
26:45duplicate
26:47duplicate
26:49remove
26:51remove
26:53remove
26:55remove
26:57remove
26:59table
27:01choose
27:03tables
27:05format
27:07and
27:09stripe
27:11and
27:13issue date
27:15issue date
27:17year
27:19already
27:21days
27:23then
27:25loan status
27:27and
27:29verification status
27:31and
27:33term
27:35and
27:37term
27:39and
27:41here
27:43interest rate
27:45and
27:47average
27:49interest rate
27:51and
27:53you
27:55have to
27:57score
27:59and
28:01average loan amount
28:03and
28:05average loan amount
28:07and
28:09here
28:11here
28:13id
28:15x-axis
28:17issue date
28:19issue date
28:21quarter
28:23quarter
28:25quarter
28:27and
28:29we
28:31can
28:33see
28:35this
28:37is
28:39format
28:41format
28:43and
28:45marker
28:47on
28:49marker
28:51color
28:53color
28:55and
28:57this
28:59is
29:01right
29:03and
29:05this
29:07is
29:09this
29:11is
29:13this
29:15is
29:17this
29:19is
29:21this
29:23is
29:25this
29:27is
29:29total
29:33total
29:57now what we will do next
30:01this one will change
30:03this next one will select rest of column
30:06and here we will click verification
30:09account id and here we will click verification
30:12first that happens
30:14and what happens to me
30:17so its own status
30:19i think the own status will come first
30:24I can confirm this
30:30This has to do the terms of yes, and I will also show which means
30:35and then I will show you the result
30:40and I will show you his message
30:45and I will show you how to make more information
30:53after this we will change the title
31:01background identity
31:08we will change the status
31:14versus verification status
31:22Here we can see Verification Status vs Load
31:27And then we can see Y axis
31:30I am off-cut
31:34Y axis values are off-cut
31:36And here we can see values
31:41And then we can own data labels
31:45Here we can see table
31:48And here we can see table
31:52Click on this tab table
31:54Click on this tab table
31:57Click on this tab table
31:59And here we can see table style
32:01Default is the board item
32:03And then we can choose alternative proof
32:06And choose values
32:08And then we can see values
32:12Now we can see
32:14Formatting is very good
32:17And then we have to see values
32:19And then we can see values
32:21And we can see values
32:23And what we can do
32:24And here we have to do
32:26Here comes the overview
32:29Overview
32:37Overview task board
32:39Let me change the overview
32:41Overview
32:43Overview
32:45and its name be capital
32:47down
32:49summary
32:51summary
32:53and you work
32:55friends
32:57filter option
32:59insert
33:01save button
33:03sorry
33:05information
33:07information
33:09information
33:11and
33:15save button
33:17and
33:19click
33:21click
33:23click
33:25click
33:27click
33:29click
33:31click
33:33click
33:35click
33:37click
33:39click
33:41drop
33:43action
33:45and
33:47eastern
33:49and
33:52answer
33:53after
33:55畫
33:57pause
33:58answer
34:00the
34:01answer
34:03this answer will be available DTI over time
34:05this answer will be available
34:07friends this type
34:09this type
34:11which you can analyze manually
34:13and you can automatically analyze
34:15you can answer answers
34:17questions
34:19then you can give it
34:21ok friends this time
34:23filter
34:25filter
34:27filter
34:29first
34:31save
34:33here
34:35drag
34:37and save
34:39and
34:41save
34:43ok
34:45save
34:47color
34:49color
34:51color
34:53color
34:55color
34:57color
34:59color
35:05save
35:07color
35:09color
35:11color
35:13color
35:15color
35:17color
35:19color
35:21color
35:23color
35:25color
35:27color
35:29color
35:31color
35:33color
35:35color
35:43major
35:45color
35:47color
35:49color
35:51let's all
35:52ок
35:53then we'll do this
35:56Now we will call it some values
36:00We'll call it as pure black
36:04and then we'll call it water
36:06it's like waterizing
36:09and then we will call it
36:12Undertale
36:13and here's theиса
36:15heading
36:16select the definition
36:18filtrate
36:19the name of the font
36:21so the font will change again
36:23so i will put little black on the font
36:25so i will put it in the font
36:27and i will go on to the font
36:29decrease
36:31decrease
36:33it here
36:35just add to background
36:37set it here
36:39butically
36:41it will have been off
36:42so you can see it
36:44you will show the phone
36:46you will see
36:48buttons
36:49we can use the button
36:53time
36:56I have blank button
37:01λ
37:04I want to use the button
37:14The button is
37:16we will select the button, and then we will select the button
37:22We will select the arrow and we will select the arrow
37:38let your style
37:42I can map the object line touchable and go for it at the same time
37:46and just keep it that you can increase
37:50here I think here
37:52I have enough filter cover
37:54which type of filter cover I will be able to do it
37:58but then I will add one more button
38:00I will set the button here
38:02and set the button here
38:04I will set the button here
38:06okay
38:08I will set the button here
38:10which type is looking up
38:12there will be like button
38:17when you reveal the new does
38:28select button here
38:30you can confirm the card
38:32if the button here
38:33I will use the link
38:35for the tool
38:37the window
38:38then then you can save
38:40save
38:42then control
38:44click on buttons
38:46and save
38:48then you can write
38:50and you can group
38:52then you can group
38:54then you can name
38:56filter
38:58filter
39:00and you can
39:02open color voice
39:04and mark
39:06open filter
39:08open filter
39:10and second bookmark
39:12close filter
39:14close filter
39:16and
39:18close filter
39:20click on
39:22click on
39:24close filter
39:26and
39:28open filter
39:30close
39:32close
39:34in the
39:36app
39:38and
39:40click on
39:42and
39:44click on
39:46bookmark
39:48open filter
39:50open filter
39:52second
39:53color
39:56button
39:58and
40:00click on
40:02so click mark and click close
40:06here you can see Skype to show
40:09now I can use this
40:12just click click
40:15filter section
40:18close
40:20same thing you can click
40:22control
40:24on off
40:26here you can see
40:28mapping
40:30here you can filter
40:34then here you can insert
40:36here you can insert
40:38here you can
40:40navigation
40:42here you can open
40:44here you can
40:46here you can
40:48here you can
40:50save
40:52here
40:54here
40:56save
40:58here you can
41:00click
41:02here you can
41:04vertical
41:06here you can
41:08click
41:10click
41:12click
41:14click
41:16click
41:18click
41:20here you can
41:22click
41:24click
41:26click
41:28insert
41:30insert
41:32image
41:34click
41:36click
41:38click
41:40click
41:42background
41:44background
41:46background
41:48putting
41:50put
41:52put
41:54put
41:56put
41:58put
42:00put
42:02put
42:04put
42:06put
42:08control
42:10and
42:12same thing
42:14you can do
42:16right arrow
42:18right arrow
42:20style
42:24style
42:26style
42:28style
42:30style
42:32style
42:34so
42:36let's go
42:38here
42:40and
42:42here
42:44here
42:46here
42:48here
42:50here
42:52here
42:54here
42:56here
42:58here
43:02that
43:04there
43:06you can
43:08come
43:10in
43:12here
43:14i
43:16remove theuğum and i also cover summary
43:20summary pech, you can also choose the slice of the area
43:23then you can see the slice of the area
43:27you can open the유ge
43:29and the slice of the area
43:32paste, apply all the slice of the area
43:35apply all the slice of the area
43:37pa's pass
43:39so
43:43so
43:47then i just need to apply all the files and here's it
43:51just like 3dp and here we can put 3dp
43:55so i think now we are pushing this different thing
43:59here we can always say
44:033dp
44:07so
44:09so
44:11you can use
44:13the
44:15buttons
44:17apply all slicer
44:19all slicer
44:21all slicer
44:23all slicer
44:25all slicer
44:27all slicer
44:29all slicer
44:31all slicer
44:33all slicer
44:41all slicer
44:43all slicer
44:45today we will be setting up the tab
44:54this is the name of the page navigator
44:57and it will be the name of the page navigator
45:00this is the name of the page navigator
45:06the name of the page navigator
45:09yeah
45:11yeah
45:13you
45:17never
45:19I
45:21don't
45:23I
45:25I
45:27I
45:29I
45:31I will click the summary option
45:34I will click the summary option
45:37I will click the down button
45:39You can click the section section
45:42You can click the page card
45:45You can click the type of filter
45:47You can click the button
45:50And then you can click the right arrow
45:52Then you can click the right arrow
45:55In this format, you can apply
45:57which needs the strawberry option
46:02Your click the
46:08Type will change the type button
46:09Price the keyboard click the window
46:11I will click the type button
46:13Then you can click the filter filter
46:16I am allowed to select the type button
46:19I will click the Caro Cookie button
46:22I will click the filter option
46:24I will click the open button
46:27Okay.
46:29I will show you what you can do.
46:33You can use your filter.
46:37You can see the filter.
46:39We can see the format.
46:42Save the color.
46:45You can see the color.
46:47You can see the color.
46:51You can see the color.
46:53You can see the color is interact with.
46:59If you should see see the color.
47:01I will bring the color between color to color.
47:03I pretty much.
47:05You just can guess what you need to see.
47:06How to put on?
47:08The color either.
47:10I can see the color.
47:12I can do that.
47:14The color to the color.
47:16If I made...
47:17And in the color...
47:19After X type,
47:22I will use this to create a slicer setting
47:29but here we will use the verticals
47:34I will use the drop down menu
47:36I will use this to drop down
47:38I will use this filter to add
47:40and click again
47:42and I will use the filter
47:44and the filter is the alone status
47:47and the purpose according
47:48you can see it in purpose according to the according
47:53which is the values
47:56you can also see it
47:57after the slicer setting
48:00you can see the article in the list
48:03then you can see it
48:05you can see it
48:08you can see it
48:10you can see it
48:12you can see it
48:18in drop
48:23and you can paste
48:25then in between
48:26you can click on to hit the button
48:29then you can paste the button
48:31you can paste the button
48:33before adding
48:35you can paste the button
48:37but this button will get to the left
48:39then you can paste the button
48:41now you can paste
48:43this button
48:45and here you can click save button and click reset button
48:52and here you can click reset all option
48:57I am going to click style and here you can fill the icon
49:01I am going to fill the icon and I am going to fill the icon
49:05which will increase the width
49:08I am going to increase the width
49:11and here you can click on the button
49:15you can click on the button
49:17you can click on the button
49:19the button is the slicer
49:21and then save
49:23save
49:25and then save
49:27and then root
49:29root
49:31root
49:33root
49:35filter
49:37filter
49:39open
49:49open
49:51open
49:53open
49:55two
49:57et
49:59close
50:01close
50:03close to
50:06close to
50:08and here we go to the action
50:10which is the action
50:12which is the action
50:14I will do
50:15I will do
50:17close to
50:18close to
50:20and I will hide
50:22and update
50:24then I will see
50:26and here we will see
50:28and close to
50:30close to
50:32remove push
50:34and here we go to the hook mark
50:36and
50:38open to
50:39open to
50:40then
50:42click to
50:43click
50:44and
50:45click
50:48click
50:50click
50:51click
50:52click
50:54click
50:55click
50:56click
50:57click
50:59friends only you can see, then you can see.
51:03and you can see the search as you can see,
51:04so we will click in this section.
51:08so we have the action,
51:09here we will see.
51:11here we will see.
51:13we will see this type of flow.
51:15It's very useful to you.
51:18You can see this type of flow.
51:20We can see this type of flow.
51:22So we can see it as an analysis.
51:24We can see the total application,
51:25we can see the state and loan amount.
51:27and the amount of load received is the same
51:30so you can use load amount and load amount
51:35and if you can use load amount and load amount
51:36then you can use measure and use table
51:39again you can use power query
51:42and use loss and profit column
51:45and use this column
51:48and receive amount
51:51and then you can use profit and loss
51:54ok friends
51:57then you can use the same
51:59overview
52:01you can use the same
52:03overview
52:05source verified
52:07source verified
52:09not verified
52:11February and May
52:13only two application
52:15after six months
52:17after six months
52:19before six months
52:21after six months
52:23after six months
52:27after six months
52:29most of the application
52:31not verified
52:33start
52:34analyze
52:35my friends
52:36this video is useful
52:37thank you for watching this video
52:39you
52:41you
52:45you
52:47you
52:49you
Recommended
0:53
|
Up next
0:40
0:15
21:04
5:31
16:56
15:41
7:43