Manuel Entering Numerical Values in Excel and how to change the Values to Percentage in power bi?

[snamalok]

My excel data Set for KRA Manual enteringHi All,

Please if anyone can assist , i have a data set for board managment and manually entered their % to the Q1 ,Q2,Q3 and Q4 Progress and tried to set this numerical values to percentage in power bi but it continues to give me values like 7500% rather 75%.

and this informations are given by officer which are manually entered into the masterfile in excel, thus want to create a percentage value using these numerical values in Powerbi ?

 

[Idrissshatila · Accepted solution]

Hello @snamalok ,

as @snamalok mentioned, you need to adjust this in the excel file, the power bi doesn't read the percentage as it is.

so what I recommend you to do is to make the percentage for example 50% as 0.5 in excel then you mark it in power bi as percentage so it converts to 50%.

[snamalok]

 @Idrissshatila, @Hansolu,  @v-kpoloju-msft  THankyou very much so i did change the data type to decimal also from the masterfile and convert the data type to percentage inorder to read the percentage in Power and it did please once again for every solutions mentioned

[v-kpoloju-msft · Accepted solution]

Hi @snamalok,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to @Idrissshatila, @Hansolu, for his inputs on this thread.

What is happening is that Power BI is interpreting your “75” as 75 whole units, and then the Percentage format multiplies that by 100, which is why you are seeing 7500% instead of 75%.

To fix this, the underlying values need to be stored as decimals (e.g., 0.75) before formatting as a percentage. You can do this in a couple of ways:

Adjust in Excel before importing: If you control the source file, multiply the percentage columns by 0.01 so that 75 becomes 0.75, then save and refresh Power BI.

Fix inside Power BI (Power Query): Go to Home → Transform Data. Select the Q1/Q2/Q3/Q4 Progress columns. Change the data type to Decimal Number. Use Transform → Standard → Divide and divide values by 100 (or use a conditional formula if some values are already decimals). Close & apply, then format the column as a Percentage in the Modelling tab.

Once the numbers are stored as 0.75 instead of 75, Power BI will display them correctly as 75%. Refer this link: Data types in Power BI Desktop - Power BI | Microsoft Learn

Hope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.
Thank you.

[v-kpoloju-msft]

Hi @snamalok,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[Idrissshatila · Accepted solution]

Hello @snamalok ,

as @snamalok mentioned, you need to adjust this in the excel file, the power bi doesn't read the percentage as it is.

so what I recommend you to do is to make the percentage for example 50% as 0.5 in excel then you mark it in power bi as percentage so it converts to 50%.

[Hansolu]

HI,

PowerBi just read the excel file. In excel you do not have the cells formatted as %, they are just numbers.

Meaning 75 as number with the header %. In Excel as well as in powerbi 1  = 100% so if you use a number and change it to % data type, your 75 in excel will become 7500 % 

Thats the same in excel as well, just try to change the cell format to % and you see the same number as in powerbi.

solution:

Prepare your datasource properly, your excel file, or, not recomended, do some transformation in powerbi like divide by 100