Forum Discussion
Solved
Scientific Number in Text Field
I have a text field showing numbers in scientific notation. Can anyone advise how to correct this to show the highlighted number at the bottom please? To clarify, this needs to be text column as...
We ended up changing the data type in the source data to a numeric field, as nothing seemed to work in Power BI unfortunately. Thanks to those who offered suggestions! Must be a techincal issue.
danextian
Super User
Super UserHi knagarlmet
It's werid that the value is shown in scientific notation even though the data type is text. What's even werider is that the numbers appear italicized and right-aligned just like how numbers are typically displayed in the query editor. I have created a dummy table in sql containing a long string of numbers and set the data type to number. Power Query displays it correctly. Have you tried explicitly changing the data type yourself as text instead of relying on the default schema from the database? Otherwise, try these custom columns
Text.From([Column])
Text.From([Column]) & ""