topic Re: category.source.type.underlyingType in Custom Visuals Development Discussion

category.source.type.underlyingType

rdegr — Tue, 16 Oct 2018 22:00:26 GMT

I can't find a lookup for the values in this field, can anyone point me in the right direction? Thanks!

Re: category.source.type.underlyingType

v-viig — Wed, 17 Oct 2018 09:21:36 GMT

Not sure if understand the issue well. Do you want to detect column type?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: category.source.type.underlyingType

rdegr — Wed, 17 Oct 2018 13:19:32 GMT

Yes, exactly. This has numeric codes, I'd like to know what they map to.

Re: category.source.type.underlyingType

v-viig — Thu, 18 Oct 2018 11:10:42 GMT

To detect column type please use metadata.type.numeric

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: category.source.type.underlyingType

rdegr — Thu, 18 Oct 2018 13:18:28 GMT

Other parts of the API appear to distinguish "double" from "decimal". So that "valueEncoded" for a numeric might be digits followed by an M or a D (or L for integer). How to distinguish "double" from "decimal"?

Re: category.source.type.underlyingType

rdegr — Thu, 18 Oct 2018 13:32:42 GMT

As seen here in the PrimitiveValueEncoding class https://github.com/deldersveld/PowerBI-visuals/blob/master/src/Clients/VisualsData/semanticQuery/primitiveValueEncoding.ts

Re: category.source.type.underlyingType

jppp — Thu, 18 Oct 2018 14:54:14 GMT

The `category.source.type` has to values that determine the real type if you are really interested: the `primitaveType` and the `extendedType`.

Both are enums and a pretty accurate definition is available at:

https://github.com/avontd2868/PowerBI-visuals/blob/c0278829a474f2b3f4dec1c8f0adb41fc4814fbf/src/Clients/Data/types/valueType.ts#L401

https://github.com/avontd2868/PowerBI-visuals/blob/c0278829a474f2b3f4dec1c8f0adb41fc4814fbf/src/Clients/Data/types/valueType.ts#L418

In case of the screenshot Ignat: the primitiveType is 3 (`Double`) and extendedType 259 (`Double`).

And to determine the difference between a `Double` and `Decimal` is the extendedType property: `259` vs `258`

-JP