display a percent from a non calculated measure

[jjasper]

Hello,

I have created a table that has two columns. The second column is a percent complete column. I would like to make this card but when I do it shows it a 0.99 instead of 99%. I would like to be able to display it as 99%, I am unsure of how to do this. Everything I have looked at is how to display as a percent if it is a calculated measure but mine is not, it is pulled in from an excel file.

[MFelix]

Hi @jjasper,

You need to format the column as a %.

You must select the column and on the modeling tab select the data type as %.

Regards,

MFelix

[jjasper]

I have done that but the percent section is grayed out so I am unable to click on it to make it a percent. I am not sure if it has something to do with how my column is set up.

Thanks

Jes

[MFelix]

Hi @jjasper,

Check on the top of the formatting if the type of your data is number? If it's text you first need to change it to number and then apply the %.

Regards,

MFelix

[jjasper]

It is a number. I still can't get it to give me the option to change it to a percent. I am not sure what I am doing wrong and why I can't get it to show. It is still grayed out even as a number option. Maybe I just can't do it.

Thanks

Jes

[v-cherch-msft]

Hi @jjasper

Did you select the column first then choose the percent? If it is not your case, please share your data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.

Regards,

Cherie