Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rdegr
Helper I
Helper I

category.source.type.underlyingType

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

1 ACCEPTED SOLUTION

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/Clie...

https://github.com/avontd2868/PowerBI-visuals/blob/c0278829a474f2b3f4dec1c8f0adb41fc4814fbf/src/Clie...

 

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

View solution in original post

6 REPLIES 6
v-viig
Community Champion
Community Champion

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

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

v-viig
Community Champion
Community Champion

To detect column type please use metadata.type.numeric

 

image.png

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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"?

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/Clie...

https://github.com/avontd2868/PowerBI-visuals/blob/c0278829a474f2b3f4dec1c8f0adb41fc4814fbf/src/Clie...

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors