Forum Discussion

ChrisPBI's avatar
ChrisPBI
Icon for Advocate III rankAdvocate III
10 years ago

Decimal Point.

Hello everyone,   Power BI gives me all numbers as:                                     I would expect 2,265.60.   I have the english version and my location is set t...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

ChrisPBI

 

Check the format setting in the control panel in your local PC. It would affect how numbers present locally.

 

In my case, setting format as "Italian(Italy)" uses a comma as the decimal point. Switch the format to English(United States) and reopen the pbix  should work. Anyway, it is not a problem after publishing.

 

 

ChrisPBI's avatar
ChrisPBI
Icon for Advocate III rankAdvocate III
10 years ago

Eric_Zhang

 

I changed the Windows settings, but it does not effect Power BI.

 

Regards,

Chris

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable Member
    10 years ago

    I believe when one options the visual's value to do math....that there is no ability to control the precision display.  It is a feature that should be added as typically selecting the option to Average can result in long decimal displays that users just are always going to ask about ......