How to remove decimals on percents?

[Anonymous]

Hi All, 

Silly question, but I can't figure out how to remove decimals on a percent table. I tried to change it on Modelling > Formatting, but it doesn't work. Neither on the data table. 

Any idea? 

Thanks in advance! 

[themistoklis]

@Anonymous

Are you sure the formattin parameters look like this?

Also, when you load the data do you load them with the % symbol? If this is the case maybe it is recognised as text field

[Anonymous]

thank you @themistoklis but I tried both solutions you mentioned, none of them work

[themistoklis]

Can you share a sample dataset with us? Mask any sensitive data

[Anonymous]

Sure : https://ufile.io/8fxyj

[v-piga-msft]

Hi @Anonymous,

Based on your datasets, I cannot reproduce your issue.

If it is convenient, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[themistoklis]

any chance to share the actual workspace with us so as to see the calculations?

Thanks