Bug in visual after update

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.