Forum Discussion

Randy's avatar
Randy
Advocate I
10 years ago
Solved

Localization numeric formatting (periods and commas)

In the Netherlands, as well as a lot of other countries, we use commas to indicate the decimal place. We also use periods to seperate thousands, but only for currencies.   I have a PowerPivot datas...
Need Help
  • Tishchenko's avatar
    Tishchenko
    10 years ago

    this bug was fixed in build 11.0.9169.163 (23-dec-2015)

     

    Thanks!!!

Randy's avatar
Randy
Advocate I
10 years ago

I refreshed my reports on PBI service and unfortunately its not fixed yet.

 

My reports are still showing dots instead of commas and vice versa. Build 11.0.9169.208

Tishchenko's avatar
Tishchenko
Responsive Resident
10 years ago

Yes, national formating hell was reborn from today weekly update 11.0.9169.208 ;-)

And new bug: time values always = 00:00

 

SSAS,Enterprise gateway.

 

  • Randy's avatar
    Randy
    Advocate I
    10 years ago

    So this defect is not solved yet!? Can somebody re-open this one, as it is quite important for me and my users.

    • Spotto's avatar
      Spotto
      Helper IV
      10 years ago

       

      My version is 13 and continues with this bug any tips ?

       

       

      • Rantonucci's avatar
        Rantonucci
        Regular Visitor
        8 years ago

        Hey Guys, 

        When I use the Format Function, commas are replaced by dots (Regional Settings already set for Chile).

        For Instead:

        Measure = Format(Calculate(sum(xx), Filters...), "#,##0;(#,##0)")

        If I take out the format function numbers appear with a dot  for thousands, on the contrary, i get commas. 

        Please have you got any solution for this problem?

        Best