Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
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.
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%
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy
You did not understand the problem.
BTW thank you for the quick response
i got my solution.
Hi @govind_021 ,
Add a localName in the format function like this:
Measure 3 = FORMAT(0.8,"0.00%", "en-US")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |