Forum Discussion
Same Measure - Different Results for Card and Multi-Row Card
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.
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.
5 Replies
- tackytechtom
Most Valuable Professional
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.instagram.com/tackytechtom/
Hi Tom.
Thank you for responding. A screen shot is below:
John
- 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.instagram.com/tackytechtom/
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.
Hello.
This workaround worked perfectly. Thank you.
