how to prevent scientific notation in my visuals?

[Anonymous]

I am seeing some scientific notation in my visuals:

Can I fix this in the pbix? Where shall I fix this? I dont mind seeing a very small number or 0, but not scientific notation!

(I am consuming from SSAS)

[v-jingzhang]

Hi @Anonymous 

Is this a measure or a column in the SSAS model? If it's a column, you can try creating a measure e.g. Measure = SUM('Table'[Column]) and change the format of this new measure. Then use the new measure in visuals on the report in place of the original column. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[DimaMD]

Hi @Anonymous I suspect that the measure is written incorrectly in your SSAS