Bug in visual after update

[ArquimedesP]

Hi, since the last update of power bi there are some kind of weird bugs. First the "Copy Table" bug which was fixed but now I have a new problema with table visual wich takes columns from a table but it changes mi data. 

This is my Table Visual data:

This is my data Table:

The firts two are diffrent from my data and I don't know why. I'm not doing any calculation over the column, I just only drag it to the visual. I built in a clean new power bi desktop file only the table I using and the problem is the same.

[ArquimedesP]

Thanks @Ashish_Mathur  and @Anonymous for your help. 

[Anonymous · Accepted solution]

Hi, @ArquimedesP 

First of all, thank you very much for your feedback.

Your solution is great @Ashish_Mathur . After my testing, it does show the wrong numeric value in the visual, as shown in the following image:

The reason for this discrepancy is that the data is outside the safe numeric size of the Power BI visual:

Data types in Power BI Desktop - Power BI | Microsoft Learn

The largest number Power BI visuals can safely express is 9,007,199,254,740,991 (2^53-1)

9007199254740991 - 9816587000100023 = -809387746359032

You can change this column to text type to get the correct display or change the format to the scientific type as shown in the image below:

I'm testing in scientific format to see if it's equal to the original value:

The February 2024 and March 2024 versions were used for the above tests.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the Query Editor, change the data type of that column to text.  Does the problem get resolved now?