Decimal to Percentage

[Kalachuchi]

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?

[v-henryk-mstf · Accepted solution]

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.

[amitchandak]

@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