% sign on the value

[sraj]

Hi,

This has never happened to me before, I am working with an excel file that comes with column User Percent value as such 99.23, 99.41, 97.10 or 78.90.  I was trying to place the percent sign next to it but when I do that the value changes from 99.23 to 9923.10, 9941.34, 9710.22  what can I do to see the value as 99.23% & 99.41%.  

Thank you!

[othy_bi · Accepted solution]

Hi @sraj 

In a new column called (%value) divide the column which contains the values you want to display by 100. Add then this new column in your visual and enable % in the menu

Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated

[sraj]

That worked, thank you!!