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.
Hi,
I have a column abc, data type is Whole Number where one of the value is 20. Now i want to show it as 20 % but when i am using Modeling tab --> Format - Percentage then it is showing me 2000 % and if i use Standard deviation then value is showing 0.00.
.
Could you plz help me with this.
Solved! Go to Solution.
The value cannot be changed from whole number into % as a percentage means that the value is divided by 100.
You can do one of 3 changes:
1. create a new column to divide the values by 100, e.g. column = [abc] / 100
2. concatenate % sign to the value, but the result will be text, e.g. column = [abc] & "%"
3. change the original calculation where the value came from, e.g. abc = <calculation> / 100
Hi SubhamK,
Whole number divided by 100 and then apply percentage format in your modelling tab. This would helps.
Normally Percentage format would multiply your number with 100.
Ex. Whole Number is 20
20/100 = 0.2
0.2 * 100 = 20%
Regards,
Pradeep
The value cannot be changed from whole number into % as a percentage means that the value is divided by 100.
You can do one of 3 changes:
1. create a new column to divide the values by 100, e.g. column = [abc] / 100
2. concatenate % sign to the value, but the result will be text, e.g. column = [abc] & "%"
3. change the original calculation where the value came from, e.g. abc = <calculation> / 100
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 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |