Turn off scientific notation in matrix

[gus_aav]

I have a matrix added to my report, and small values are showing with scientific notation. I don't seem to find a way in the format settings to turn this off. I just want these to show as "0". Any suggestions?

[NordicDrow · Accepted solution]

Its likely due to datatype, you can further format the datatype from column options, PowerQuery or going to relationships view, you can select the column and make a custom formating.

Other than that, this post should help solve your case:
https://community.fabric.microsoft.com/t5/Desktop/How-remove-scientific-notation-from-visual-in-Powe...