Forum Discussion
knagarlmet
1 year agoFrequent Visitor
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...
- 1 year ago
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.
knagarlmet
1 year agoFrequent Visitor
Hi Greg_Deckler. Thanks. Yes, glad it's not just me confused by this. Any advice or things I should try?
- Greg_Deckler1 year agoCommunity Champion
knagarlmet Use Advanced Editor to look at the code and maybe insert a step to specifically change the column to text? I don't know, that's really, really strange.