Same Measure - Different Results for Card and Multi-Row Card

[jselman]

I created a measure. It reads correctly in a Multi-Row Card, but incorrectly in a Card. Please see below.  Any ideas how to fix this?

Thank you.

[Anonymous · Accepted solution]

Hi @jselman ,

This issue has been submitted internally(ICM ID:231504209). Please be patient to wait for fixing. If there is any news, I will update it here.

And I reproduced your problem.

As a workaround, you can use a measure to round values between -0.000001 and 0.000001 to zero, then the automatic exponential notation format should not take place anymore. For example,

Measure = ROUND(SUM('Table'[column]),2)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jselman]

Hello.

This workaround worked perfectly. Thank you.

[tackytechtom]

Hi John,

This is strange and I have to admit that I do not know why it behaves likes this. Maybe it has something to do with the format of the other measures that you are using?

Here there were discussing something similar:

Solved: Remove Scientific notation in measure - Microsoft Power BI Community

/Tom

https://www.tackytech.blog/

https://www.instagram.com/tackytechtom/

[tackytechtom]

Hi @jselman ,

What data type is your measure?

It might solve your issue if you explicitly set the data type to what you'd like.

/Tom

https://www.tackytech.blog/

https://www.instagram.com/tackytechtom/

[jselman]

Hi Tom.

Thank you for responding.  A screen shot is below:

John