topic Re: Number Formatting Function in Developer

Number Formatting Function

Anonymous — Wed, 15 Mar 2017 21:22:02 GMT

In my custom visual, I'm trying to get the format from a measure. This passes the format of the measure to the ts file:

dataViews[0].categorical.values[0].source.format

It produces a value like: '0.0 %;-0.0 %;0.0 %' for a percent with 1 decimal and '\$#,0;(\$#,0);\$#,0' for a dollar amount.

My question is, how do I apply that to a number? There has to be a standard function, right?

Thanks

Re: Number Formatting Function

v-chuncz-msft — Fri, 17 Mar 2017 09:43:35 GMT

@Anonymous,

Based on my research, you may use valueFormatter module in Formatting Utils.

Re: Number Formatting Function

abhay03 — Fri, 02 Jun 2017 13:25:06 GMT

@Anonymous,

Did you managed to get the formatting in your visual, I am in the exact same situation.

I am using the valueFormatter but receiving error "Cannot read property 'valueFormatter' of undefined" in console even for the examples here.

Re: Number Formatting Function

Anonymous — Fri, 02 Jun 2017 13:33:03 GMT

@abhay03

I did get it working. This is an example of how I used it:

import valueFormatter = powerbi.extensibility.utils.formatting.valueFormatter;

kpiNumber = valueFormatter.create({
                        format: categorical.values[kpiRef].source.format,
                        value: 1001,
                        precision: settings.kpi.decimalPlaces
                    });

kpiNumber.format(kpi)

Good luck!

Re: Number Formatting Function

abhay03 — Mon, 05 Jun 2017 08:12:57 GMT

thanks a lot @rgodfrey. that helped.

Re: Number Formatting Function

satishr — Tue, 02 Jan 2018 09:43:14 GMT

@Anonymous I implemented your code and it works. However, the formatting doesn't change once the visual is displayed. For example, I have a number formatted as a decimal number with 3 decimal places. My custom visual shows this value correctly when I use it. But if I change the format to Percentage in the Modelling menu, it doesn't reflect. Did you face the same issue?

Re: Number Formatting Function

v-viig — Fri, 05 Jan 2018 12:31:39 GMT

@satishr How do you get column format? Do you categorical.values[valueColumnIndex].source.format to get a column format?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Number Formatting Function

satishr — Fri, 05 Jan 2018 13:29:29 GMT

@v-viigYes, I'm using categorical.values[valueColumnIndex].source.format to get the format values. I found out that sometimes this value is not available initially. So I had to put a check for its availability before getting the value. Now it works fine. Thanks