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 ALL,
We have a column which has been pre caluclated in database itslef. for one code I'm getting value as 42.57. But I want to see same value as 42.57%.
When I change the foramt as Percentage, value is changing to 4257.00 % , but I don't want that to happen. How should I get my value with percentage symbol.
Could you please help me out on this, Quick reply would be really appreciable.
Thanks,
Prudviraj
Solved! Go to Solution.
Hi, In a new calculated column Divide by 100 and change the format to percentage.
Also you can do this in Query Editor.
Regards
Victor
You can divide the existing column by 100 as told by @Vvelarde and use the percentage for newly calculated column or else do the same in your database and directly you can use the percentage over here.
You can divide the existing column by 100 as told by @Vvelarde and use the percentage for newly calculated column or else do the same in your database and directly you can use the percentage over here.
Hi, In a new calculated column Divide by 100 and change the format to percentage.
Also you can do this in Query Editor.
Regards
Victor
Thank you, It worked.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |