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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

That's what I figured. Hmm. I cannot replicate this. I created a number, 2265.60 using an Enter Data query, put it in a card visualization and set the Data label Display units to "None" and it showed up as 2,265.60. Definitely looks like a language setting kind of thing but not sure what would be causing that other than actually having a different language setting than US.

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 ..

  • CahabaData's avatar
    CahabaData
    Memorable Member
    10 years ago

    has to be a language or region setting somewhere I believe.  is the euro mode....  not sure where - from the visual down to the actual table data....the install of Power BI, or even the Operating System (this would of course affect all your apps....)

     

    I would be interested to know

    ..............and must confess - for some reason one install of Office among 5 PCs of mine gives tool tips in French and I've never fixed that so.......