Urgent help needed!! Visuals display abnormally (in scientific notation) on PBI online service

[WencyREN]

Dear all, I am facing an issue with my PBI report, the visuals I created with some calculated measures (via PBI desktop Version: 2.103.881.0 64-bit March 2022) display normally on the PBI desktop, when I publish it to the PBI online service environment (Service version13.0.17952.44), the visuals get messed up like below.

PBI service view 

PBI desktop view

I exported the underlying data from one of the 'messed-up visuals' via the PBI service, and found some anomalies in the dataset (which doesn't show up in PBI desktop dataset). The yellow highlighted value (screenshot - A) is 'exploded' by x 10000000000000 in the PBI service while stays normal in the pbix dataset. I try to check back on what transformations I have applied to the data in power query. From the orginal data source, data fileds come in in text type (screenshot - B), I changed the data type for the value column to whole number (screenshot - C), and load the transformed data to PBI frontend and then create calculated measures, visuals accordingly. Apparently, problems occur when I publish the report to PBI service as some of the data lines, they all of a sudden X 10000000000000, resulting in the messed up visuals views in above screenshots.

Please can someone help give some tips on how to solve this issue? Thank you in advance for any help, tips & tricks.

(A)

(B)

(C)

[lbendlin · Accepted solution]

When you do the type conversion you will want to include the source locale.  Use the "Change type with locale"  option instead.