Power BI - Changing data types

Hello friends and welcome to Tutorials Point

In this video we are going to see how to change data types in Power BI desktop

Now once you have uploaded your data in Power BI desktop, we have to make sure that the

data tables that we have uploaded should have some unique property to it

For an example, that I have a data table in which in one of the column I have something as

dates so I have to make sure that that particular column should have unique set of

properties and that unique set of property is the data type that we are talking

about now what are the different type of data types which are available now once you are in the power query editor you will make sure that you go to that

particular column and if you click on the very extreme left corner you will see

there is a small gesture so if you see there is ABC written down here if you

click on that button you will see there are whole bunch of option which you can give the data types of. Now if you see out here there

is decimal we have percentage date date and time we have time as well text so there are so many

bunch of options. So you must be wondering that why we need to give this data type. Now the whole

and sole purpose of power vi is that we need to project our data and we need to generate reports

So while generating this report we need to make sure that the data that we have imported it should

be very much organized. If it is organized and if it is in a proper data set, it will definitely

yields us a good result Now how to give data types and how to change data types in PowerBi desktop will be having a better understanding of it in our practical approach

Hello friends and welcome. In this video we are going to learn how to change the data types in Power BI

So let's get started off. In order to do that, I need to go to the Power query editor

So I will go to the Home tab and under the Home tab, I will click on this Edit Queries

The moment I click on Edit Query, my Power Editor, Power Query Editor opens up and I will move on to the queries

Let's say we will move to the product queries or we can move to the sales fact

All right, we can choose any query and we can change the data types of it. We will go with the sales fact table

Out here, you can see the different columns out here. All right. Now, what is the need of changing the data types and what is the peculiar use of it

So let me tell you about it for an example that we are the purpose of power BI is to create and to generate reports in a graphical format

But for an example if the data type of a particular column or a particular table is not up to date or it is not

Relevant it will not give me the result for an example as of now under the sales fact query if you can see the date column

This date column is known as like ABC you can see something called as ABC you can see something called as ABIC

So what is this ABC? This ABC is nothing but it is stored as a text in this particular column

but this is a date format and it not a text format So in order to change that I have to click on this ABC button The moment I click on this ABC the ABC is representing the text But as of now I do not want the text I want it as a date now out here you can see the different date

Types as well I can either take it as a date I can take it as date and time if you have a column which is displaying you the date and time both so I can select this particular

Option date and time or date or time we can also select time if you have time and if you are

belong to a particular time zone you can select your time zone and you can select the date accordingly

As of now we will go with the simple date format so I'll simply click on the date format the moment I click on the date format

The icon out here change so automatically it is converted into a small bit like a for calendar as you can see out here

And the date is in the date format the column isn't entirely into a date format all right now moving on the ABC this is my zip file we can change this

as well so I'll simply click on it and make this as a binary or a whole number

that would do that will make my work a little bit easier units as defined it is a

number unit or it is a let me check it's a whole number all right this is a

whole number as you can see it's a whole number out here also the next the last

column which we have is the revenue column now the revenue column you can see

something called us 1.2 so let me click on it the moment I click on 1 there nothing but my decimal unit but as it a revenue it should be in currency format all right everybody agrees so we will simply click on this particular button and I meet this as fixed decimal number that is my currency format the moment

I click on this currency format you can see this is converted into a currency

format and also you have some four digit you four decimal places after the

point all right so you can also change this by simply making the relevant changes

let's go and then change this decimal points let's make it till 2 that sounds good so I'll simply right click on my revenue column

and I will this time I will move to the column which says transform all right

the moment I click on transform I will go to the round up round the option and I'll

go to the round option out here the moment I click on round another window pops up

it is asking me how many decimals to round out 2 so I'll as of now I'll say 2 we

just want two decimal places we can see 4 it will convert it into 2

moment I hit okay now I have just two decimal places and this applied steps can

be seen out here as well all right guys so this is how you change the data types

for each and every query which you can see or the table which you can see out

here by changing the data types this is the one way of changing the data type

by clicking here another way of changing the data type is you can simply select

that column and under the home tap you can see something called as data type

If you click on this drop-down menu, you can see all those options which we were able to see out here as well

All right, guys. So this was all about this video where we learned how to change the data types in PowerBI

All right. See you until next time