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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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
Icon for Advocate III rankAdvocate III
10 years ago

I don't know how to fix that ..

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

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable 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.......