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 ?

dprasetyo's avatar
dprasetyo
Frequent Visitor
8 months ago

thanks for the suggested solution.
I've tried in power query and it shows additional "'" in there, but when I put it in the table viz, it goes back showing the E notation.

Zanqueta's avatar
Zanqueta
Super User
8 months ago

Hi dprasetyo 

Perhaps you are opening CSV files directly in Excel instead of trying the following:
Open a blank Excel file → Import Data → CSV.
When opening in Excel, use Import Data and set the column to “Text” to avoid automatic conversion.

 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.