Forum Discussion
govind_021
1 year agoSuper User
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 ...
- 1 year ago
Hi govind_021 ,
Add a localName in the format function like this:
Measure 3 = FORMAT(0.8,"0.00%", "en-US") - 1 year ago
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.
Kedar_Pande
1 year agoSuper User
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.