Format Calculation as Percentage

[Belindah]

I want to format the result of the following calculation as a percentage. I have tried using the FORMAT function, but I can't make it work. Any help is greatly appreciated!

Switch Complete = CALCULATE(SUM('table 4'[Switches]),'table 4'[Complete] = "Yes")/(SUM('table 4'[Switches])

)

[v-shex-msft]

Hi @Belindah,

You can also use field format string to change the field display format without effect the raw field values.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,
Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@Belindah Don't use FORMAT as that will turn it into text. Click on the measure in the Data pane while in the Report view. In the ribbon, find the Formatting section and click on the % icon.