Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
govind_021
Resolver III
Resolver III

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

2 ACCEPTED SOLUTIONS
Bibiano_Geraldo
Super User
Super User

Hi @govind_021 ,

Add a localName in the format function like this:

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

 

Is this post help you? Please consider to:

Accept as Solution!
Give a Kudo
Follow me on Linkedin

View solution in original post

Kedar_Pande
Super User
Super User

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

View solution in original post

5 REPLIES 5
Kedar_Pande
Super User
Super User

@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
Super User
Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


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.

Bibiano_Geraldo
Super User
Super User

Hi @govind_021 ,

Add a localName in the format function like this:

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

 

Is this post help you? Please consider to:

Accept as Solution!
Give a Kudo
Follow me on Linkedin

Thank You @Bibiano_Geraldo 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.