- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Prevent Scientific Notation
I'm dealing with some ID numbers that show up fine in Excel but get converted to Scientific Notation whenever I import them in PBI, which also changes the numbers for some reason. Is there any way to prevent scientific notation? I've tried changing the column format to text but it doesn't make a difference.
Thanks,
Pierre
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just started working actually, I added a * to the column in excel and then removed it in PBI!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a text file with chess moves like 1.e3 which keep getting changed to scientific notation.
I changed all the e's in my text file to é (e acute) and on importing into excel it left them alone.
Having e acute instead of e is a small pice to pay!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a text file with chess moves such as 1.e3 which kept getting changed to scientific notation.
I changed all the e's in my file to é (e acute) and on importing to excel it left them alone!
I don't care if 1.e3 looks like 1.é3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I stopped excel changing things like 1.e3 by changing all the e's in my input text file to é (e acute). It worked!
I don't really care if 1.e3 shows as 1.é3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'd like to play around with that, how big does the number have to be in Excel?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just started working actually, I added a * to the column in excel and then removed it in PBI!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Glad to hear that you've solved this problem. You could help accept it as solution. Your contribution is highly appreciated.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We have a similar problem. Some zeros in Tables and Matrices appear with scientific notation, dispite being set to Integer.
We solved it by rounding to two decimals with ROUND([measure], 2), and then changing the format to 'Whole number' in the Modelling tab.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please try the solution in the article here:
https://pivotronics.com/2021/06/29/getting-rid-of-scientific-format-for-decimal-numbers-in-power-bi/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-13-2017 06:37 AM | |||
03-25-2019 05:59 AM | |||
01-13-2022 05:36 AM | |||
03-09-2021 01:50 AM | |||
03-02-2023 11:36 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |