% shows in edit query but not in table?

[Anonymous]

Hi all,

Currently having some % woes. I've selected the data type of several colmsn to be a % (blue circles), but for some reason when I add this info to a simple table it re-formats it. There are no calculations here as I'm taking the info directly from excel. Can anyone help here? 

Kind regards,

Jordan 

[amitchandak · Accepted solution]

Check if the data format is %, can you remove that and check.

[Anonymous]

Both work, thank you!!

[dax · Accepted solution]

Hi @Anonymous ,

You set the % for data, but in design pane, it seems that decimal or whole number is default type, so if you want to show it, you need to set it like below(0.1%=0.001) or use % as format

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

Check if the data format is %, can you remove that and check.