Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
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
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?
What is your source? Are you using SQL
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,
I totally forgot about the 0-1, thanks for your reply 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |