How to change column from decimal to percentages?

[Periksson]

I have a column that is shown as a percentage but it display is a decimal type. I want to change it to percentages and when I do it adds two zeroes on end. I need to format the whole column first and add two decimal points on the beginning so when I change it to a percentage type it displays correctly. How do I do that? Don't judge, I'm new to Power BI.

[Mariusz]

Hi @Periksson,

Please follow the steps below
1. Go to Modeling Ribon 
2. Select your table
3. Select your column 
4. Select Percentage 
5. Adjust 0 to 2 decimal places

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

Could you provide an example on how your data looks currently?

[Periksson]

Ok, so I have, e.g. :
26,73
99,3

86,91

97,71

They are all in decimal display and I want to display them in percentage as follows:
26,73%

99,3%

86,91%

97,71%

[Gordonlilj · Accepted solution]

Right,

You could create a custom column in power query and use this code

"0." & Text.Replace([Column],",","")

This new column will make your data look like 0.2673 as an example.

The original column first need to be a text data type and you might have to change the delimiter in the code 0.0 -> 0,0 as it depends what regional settings you're using.

Then change the datatype to decimal and than you can follow what @Mariusz provided and it should work

[Periksson]

I forgot to mention, I have negative percentages also.
It's a margin percentage column. Any idea if I can incorporate

an if statement for negative cells?

I get errors when I want to close and apply the query editor because

negative cells have this data now:

0.-6321 for -63.21 e.g.

[Gordonlilj]

Hi,

Sorry, i don't have a lot of time so excuse the less elegant solution.

To make it easy i would add another simple custom column BEFORE creating the one in the previous post.

Text.Replace([Column],"-","")

This removes the negative/minus symbol (we will add it back in the next custom column)

After this change the column i provided in the previous post to this. (Make sure this column is created after the one right above)

if Text.Contains([Column],"-") 

then "-0." & Text.Replace([CustomColumn],",","")

else "0." & Text.Replace([Column],",","")

Replace [Column] with your original data column and [CustomColumn] with the simple custom column.

Then change it to decimal and then do the same procedure to changing it to percentage.

If you have any further problems just ask but it might be some time before i'm able to answer