cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

## Percentage automatically multiplies x100

Hello all,

I want to just place a percentage sign at the end of my data, but when I change from decimal number to percentage my data is multiplied by 100. So 3,4 = 340%. I don't want this, I just want 3,4% in my dataset. How can I change this?

Greetings,

0xygen.

2 ACCEPTED SOLUTIONS
Microsoft

A genuine percentage is actually a number between 0 and 1.

So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

Why not divide your number by 100 and then format it as a percentage?

Proud to be a Datanaut!

Microsoft

Hi @0xygen27,

Why so you divide 50 columns at once? Could you please share more details?

If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

Best Regards,
Angelia

6 REPLIES 6
Microsoft

A genuine percentage is actually a number between 0 and 1.

So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

Why not divide your number by 100 and then format it as a percentage?

Proud to be a Datanaut!

@Phil_SeamarkIs there a way to divide 50 colums at once?

Microsoft

What is your source?  Are you using SQL

Proud to be a Datanaut!

Microsoft

Hi @0xygen27,

Why so you divide 50 columns at once? Could you please share more details?

If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

Best Regards,
Angelia

I had a colum with percentages without the % mark, I just wanted to place a % mark behind it. It was a Opendata file, but it was just a testing file and I moved away from the file, because it wasn't good enough. Thanks for your help though 🙂

HI Phil_Seamark,

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors