Text data type displaying as number

deldersveld / rDataTable

R custom visual for Microsoft Power BI based on DT / DataTables

MIT License

14 stars 14 forks source link

Text data type displaying as number #8

Open ZedLeb opened 6 years ago

ZedLeb commented 6 years ago

I've got some codes with leading zeros which I have set as text in the Query Editor.

= Table.TransformColumnTypes(#"Expanded MASTER Template Dupes",{{"Matl Grp Pack. Matls", type text}, {"Transportation Group", type text}})

The column view confirms that the data type is Text and there is no sigma against the Field name however the R Data Table view is presenting data in these two columns as numbers.

Any ideas what might be happening?

deldersveld commented 6 years ago

The API for R visuals does not expose data type and formatting like we can get with regular custom visuals. If it looks like a number, R treats it as a number.