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
KGrice's avatar
KGrice
Memorable Member
10 years ago

Do you have the most recent version? It looks like others have had similar issues (here and here for example), but there was a fix a few versions back.

samdthompson's avatar
samdthompson
Memorable Member
10 years ago

Not sure whats behind it, as a quick fix, try wrapping a format around the measure =FORMAT(Measure,"#,###.00")

  • 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