topic Re: Custom Visual Field Formating in Custom Visuals Development Discussion

Custom Visual Field Formating

Anonymous — Fri, 30 Aug 2019 21:15:35 GMT

I'm working in a custom visual and i need to implement Field Formatting.

I want to store different settings for every metric i have inserted in the visual

like the way it is implemented in matrix visual on power bi

Is there any reference or source code on git hub on how to implement this feature

Thanks in Advance

Re: Custom Visual Field Formating

dm-p — Sat, 31 Aug 2019 01:54:46 GMT

Hi @Anonymous,

If I understand correctly, you're looking to do something like in this thread? Last we heard, this is not supported for custom visuals and only works in the core visuals, which is a shame, as I really, really want to be able to do it myself.

An alternative is to create a formatting field for each measure in the properties pane, which is not as elegant but gets the job done. The tutorial to do something similar is linked in that thread also. I have a couple of examples in a visual I produce that uses the categorical dataViewMapping (which isn't formatting but generates a text field for each category) which I can provide if this would be useful to you? You would use these in a similar way to take a format string and then use TS code to apply the formatting specified in the field.

Regards,

Daniel

Re: Custom Visual Field Formating

v-evelk — Mon, 02 Sep 2019 14:51:42 GMT

Hello,

Try to use this utility please.

You could check MultiKPI visual repository, for instance, to find how to store and work with a format.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Custom Visual Field Formating

Anonymous — Tue, 10 Sep 2019 06:44:58 GMT

can you provide me the code that you mention?

Re: Custom Visual Field Formating

v-evelk — Tue, 10 Sep 2019 15:26:53 GMT

First of all, you should create a formatter.

Here, you should pass a format.

Then, you should call "format" function of the formatter that will return formatted value.

I hope that it will help.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Custom Visual Field Formating

Anonymous — Fri, 13 Sep 2019 14:14:43 GMT

in the dropdown which i have in the settings in order to select the metric i do not see the names

of the metrics although i pass them correctly. Any ideas?

Re: Custom Visual Field Formating

v-evelk — Mon, 16 Sep 2019 14:44:59 GMT

Hi,

I should see how you set it inside capabilities.json to figure out what is wrong.

I can only suggest that you didn't set "displayName" property for an item as on below picture.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com