Advance-Card icon indicating copy to clipboard operation
Advance-Card copied to clipboard

Published 20 hours ago • verified publisher icon bhavesh-jadav

Wrong numberformat

Open ddekockproanalytics opened this issue 5 years ago • 6 comments

Description The numberformat in the Advance Card is different from the rest of Power BI. In attached an image where you can see two numberformats:

  1. In the advanced card (in the top part of the image), using a comma to as a thousands seperator
  2. In the default bar chart, using a dot as a thousands seperator

GitHub

I want both numbers to be formatted the same way, where the dot as a thousands seperator is the one I am looking for. I've tried some other formats (like whole number, without currencysymbol, etc.) and it happens in all these occasions.

ddekockproanalytics avatar May 27 '19 08:05 ddekockproanalytics

@ddekockproanalytics

Do you see same results in Power BI Online?

Are you using Power BI Desktop version with correct locale? You can go to below link and select your language instead of English and download the Power BI desktop https://www.microsoft.com/en-us/download/details.aspx?id=45331

Builtin visuals take locale settings from your system whereas custom visuals takes locale settings from Power BI desktop

bhavesh-jadav avatar May 27 '19 08:05 bhavesh-jadav

Hi @bhavesh-jadav,

Thanks for the quick reply! I did use an English version of Power BI but after your comment I switched to a Dutch installation. I did this on two different machines but the results stay the same. In the screenshot below you can see that the options under Display Units are in a different language (Dutch) coming from the installation of Power BI:

Github 2

Same goes for the Power BI Service. It is set to Dutch (Nederlands) but the numberformat is the same as shown in the screenshots:

Github 3

Do you know other settings I can look at?

ddekockproanalytics avatar May 27 '19 08:05 ddekockproanalytics

@bhavesh-jadav,

One more thing: I've tested the Dutch installation of Power BI on both an existing Power BI document and a new one I just created. Both have the same result.

ddekockproanalytics avatar May 27 '19 08:05 ddekockproanalytics

I'm having the same issue. It's also listed in this topic: https://github.com/bhavesh-jadav/Advance-Card/issues/6

A fix would be very much appreciated because this visual is awesome!

svenvu avatar Aug 18 '19 08:08 svenvu

I'm having the same issue. metrics in other visualisations work. I am also a dutch power BI user. In the advanced card i get "," instead of ".".

Also in PowerBI online it's not correct.

dirkgroen avatar Dec 28 '20 12:12 dirkgroen

I also have this issue, also a Dutch power BI user. Rather sad as it makes a great visual with some great features worthless.

PetervdVeenSubadvies avatar Dec 29 '20 12:12 PetervdVeenSubadvies