decimal places and percentage issue

[HarryB]

Hi Team,

Please can you help me with an issue that I am having.

The data on my power bi visual table looks like this

But i want it to look like this 

My table data view looks like this

Please can you guide me on how to fix this.

Thanks

[Daniel29195 · Accepted solution]

@HarryB 

try to divide in power query your column with 100. 

so example if you have , 32.78 . in power query if you divide by 100 --> 0.3278 

then you change the format to percentage -->  you will get 32.78% 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:

[HarryB]

@Daniel29195 this worked thank you