Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
0xygen27
Advocate II
Advocate II

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
Phil_Seamark
Employee
Employee

Hi @0xygen27

 

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

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.

 

 

1.PNG

 

Best Regards,
Angelia

View solution in original post

6 REPLIES 6
Phil_Seamark
Employee
Employee

Hi @0xygen27

 

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

What is your source?  Are you using SQL


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.

 

 

1.PNG

 

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,

I totally forgot about the 0-1, thanks for your reply 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.