topic Re: valueFormatter ignores culture for displayUnit in Developer

valueFormatter ignores culture for displayUnit

Martin18 — Sat, 18 Aug 2018 09:32:58 GMT

Hi all,

I'm having little trouble with valueFormatter as I can't get it format my values as expected in terms of the unit abbreviation and the given culture. Even though it produces the correct decimal character (comma), the unit abbreviation still looks like for the default culture ("en-US").

Here's what I've done:

visual.ts:

import valueFormatter = powerbi.extensibility.utils.formatting.valueFormatter;
...
let formatterOptions : utils.formatting.ValueFormatterOptions = {
	value: 1000,
	precision: 1,
	cultureSelector: options.host.locale // "de-DE"
}; 
let formatter = valueFormatter.create(formatterOptions);
let v = formatter.format(2500); // gives 2,5K and not 2,5 Tsd. 😞

pbiviz.json:

... 
"externalJS": [
    "node_modules/globalize/lib/globalize.js",
    "node_modules/globalize/lib/cultures/globalize.cultures.js",
...

Is there anything wrong with my code?

Any help will be appreciated. Thank you.

Re: valueFormatter ignores culture for displayUnit

v-viig — Mon, 20 Aug 2018 07:39:03 GMT

It looks like postfix has not been localized for all of languages.

Please create a new bug in GitHub: https://github.com/Microsoft/powerbi-visuals-utils-formattingutils

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: valueFormatter ignores culture for displayUnit

popov — Sat, 22 Dec 2018 18:48:25 GMT

I'm using formatting utils with new powerbi-visual-tools 3 (beta) and get some behavior. When this bug will fix?

Re: valueFormatter ignores culture for displayUnit

v-viig — Mon, 24 Dec 2018 07:06:17 GMT

Did you face exactly the same issue?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com