Forum Discussion
Percentage Formatting
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
Hi govind_021 ,
Add a localName in the format function like this:
Measure 3 = FORMAT(0.8,"0.00%", "en-US")
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.
5 Replies
Hi govind_021 ,
Add a localName in the format function like this:
Measure 3 = FORMAT(0.8,"0.00%", "en-US")Thank You Bibiano_Geraldo
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.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%Hi Fowmy
You did not understand the problem.
BTW thank you for the quick response
i got my solution.
