Showing text column value as percentage on a card visualisation

[Huni31]

Hello,

I'm new to Power BI so any detailed explanation would be really helpful. I have a text column which holds percentage values that I'd like to display as a card visualisation. At the moment it looks like the attached screenshot, showing decimal not percentage. Is there a way to have it show percentage? I can't change the text column as the text in the column is needed. Many , many thanks! Leeit's not in percentage but in decimal 0.6666666

[Uzi2019]

hi @Huni31 

You can use % symbol for percentage representation.

Change the column type from text to decimal number

I hope it might help you!

[DataNinja777 · Accepted solution]

Hi @Huni31 

Normally, you would aggregate in a measure to show in a card visual assuming that you have more than 1 rows in your text column.  You can wrap the text measure in value to convert it to a numerical format, and then apply format function to convert to % as shown below.

Best regards,