Percentage Formatting

[govind_021]

Hi All , Need Help
I am using measure in tooltip and i have used format function to convert the value into percentage 
Format ( 0.8 , "0.00%" )
but it is showing me in tooltip 80,00 % not decimal point ( 80.00%) 
why is this happening

[Bibiano_Geraldo · Accepted solution]

Hi @govind_021 ,

Add a localName in the format function like this:

Measure 3 = FORMAT(0.8,"0.00%", "en-US")

[Kedar_Pande · Accepted solution]

@govind_021 

The issue is caused by your system's regional settings. The comma , is being used as a decimal separator instead of a period ..

To fix this:

Go to File > Options and Settings > Options > Regional Settings in Power BI.
Change the Locale to a region that uses a period . as a decimal separator
Refresh the report.

[Fowmy]

@govind_021 

0.8 represents 80%, if you need 8% then Format ( 0.08 , "0.00%" ) or  Format ( 0.008 , "0.00%" ) for 0.8%

[govind_021]

Hi @Fowmy 
You did not understand the problem.
BTW thank you for the quick response 
i got my solution.

[Bibiano_Geraldo · Accepted solution]

Hi @govind_021 ,

Add a localName in the format function like this:

Measure 3 = FORMAT(0.8,"0.00%", "en-US")

[govind_021]

Thank You @Bibiano_Geraldo