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
KGrice's avatar
KGrice
Icon for Memorable Member rankMemorable 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
Icon for Memorable Member rankMemorable 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
    Icon for Advocate III rankAdvocate 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
      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