Forum Discussion

dprasetyo's avatar
dprasetyo
Frequent Visitor
8 months ago
Solved

Text Field was Read as Scientific Number

Hi, I have a problem in showing pure text data type in Table kind of visualisation. In my ID column, I have several rows consist of multiple IDs (that's why I set it to text data type in csv and in ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    8 months ago

    Hi dprasetyo 

    Is the scientific notation appearing in Power Query Editor, in the data view, or only in a report visual?

    After changing the column to Text, did you apply the change in Power Query and click Close & Apply?

    Is there any step in Power Query (for example Changed Type or Added Custom Column) that might be converting the value back to a number?

    can you share the error screenshot or sample CSV data file ?

AntoineW's avatar
AntoineW
Super User
8 months ago

Hi dprasetyo,

 

Can you check if the data type of the column ID is changed to TEXT with Power Query ?

You can force Text Rendering by creating a measure 

 

ID_Display =
FORMAT ( TableA[ID], "@" )

 

OR 

 

ID_Display =
"" & TableA[ID]

 

 

Use ID_Display only in visuals.

 

Hope it can help you!

Best regards,

Antoine

dprasetyo's avatar
dprasetyo
Frequent Visitor
8 months ago

thanks for the suggestion.
I've tried both but it still shows notation symbol.