Forum Discussion
Helper IIIDecimal to Percentage
Hello guys I have a column where values are 0.9, 3.6 and 12.2 which is in Decimal Number Data Type. I am trying to make it to percentage format but what happens is it becomes 90%, 360% and 1220% while it sshould be 0.9%, 3.6% and 12.2%. Anyone knows any workaround with this?
Hi Kalachuchi ,
Refer to the following steps:
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Kalachuchi , Create a new column divide by 100 and then use that along with %
OR try if the formatting in model view can help
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
v-henryk-mstfCommunity Support
Hi Kalachuchi ,
Refer to the following steps:
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
