change 0.5 to 0.5%

[engingee]

Hi everyone,

I have a got the number of 0.5, and I would like to show it as 0.5% , but when I applied % in power BI, it becomes 50%.

Is there any way can do that in Power Bi please? Many thanks!

[AlexisOlson · Accepted solution]

Can you divide the column by 100 and then apply the percentage format? This is probably the best approach.

If not, you can apply a custom format that just tacks on a percentage sign. (Use the backslash to escape the percentage character from being interpreted in the normal way.)