Forum Discussion

ChrisPBI's avatar
ChrisPBI
Advocate 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
ChrisPBI's avatar
ChrisPBI
Advocate III
10 years ago

Since this applies to entire pages a formating function is not enough.

 

Maybe is really my system. The iOS application acts the same way.

 

Hmm .. Power BI Team .. please ..

Eric_Zhang's avatar
Eric_Zhang
Microsoft 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
    Advocate III
    10 years ago

    Eric_Zhang

     

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

     

    Regards,

    Chris

  • CahabaData's avatar
    CahabaData
    Memorable 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 ......