Solved: Format Calculation as Percentage

Belindah · ‎06-17-2024

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])

)

Greg_Deckler · ‎06-17-2024

@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.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

v-shex-msft · ‎06-19-2024

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Greg_Deckler · ‎06-17-2024

@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.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...