How to get rid of scientific notation in Power BI Desktop ?

[gvg]

Hi folks,

I have a decimal format column coming from Power Query. My measure calculates some value on that column in Power BI. However when I put it in a matrix visual, the numbers that are evaluated to 0 are shown in scientific notation regardless of the format set to be decimal. How to force that measure to show in decimal, not scientific notation?

Thank you for any hints.

[lbendlin]

you can specify the number of decimals you want to use.

[gvg]

No, this doesn't work in matrix.

[amikm]

Hi @gvg,

Are you using a live connection to connect data to the Power BI desktop?
If yes, then you can't change the datatype of measures in the Power BI desktop. you need to change it inside the tabular model itself. If now, you can change the data type in the Power BI desktop itself. Try to increase the no. of decimal places.

Regards,
Amit

[gvg]

Hi,

I am using import method to deal with my data source. Sure I changed the format, but it does not work in matrix visual.