Forum Discussion

govind_021's avatar
govind_021
Super User
1 year ago
Solved

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 ...
  • Bibiano_Geraldo's avatar
    1 year ago

    Hi govind_021 ,

    Add a localName in the format function like this:

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

     

  • Kedar_Pande's avatar
    1 year ago

    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.