Forum Discussion
Turn off scientific notation in matrix
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?
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-Power-BI/td-p/3109685
1 Reply
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-Power-BI/td-p/3109685