Forum Discussion
Format Calculation as Percentage
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!
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.
2 Replies
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.
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
