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

I don't know how to fix that ..

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.