Forum Discussion
Disable Exponent format in Card Visualization
I'm having difficulty with making a card display as 0.00.
This is as the card displays now.
However, the same column displays as 0.00 in a table on the same report page.
For the card visualization, I've made sure to set it to 2 decimal places.
And the column is set at the Data Level to display as a decimal number with only 2 decimal places.
Yet for some reason, it still displays a very small decimal in exponential form on the card visualization. Is there a way to fix this so it just reads 0.00?
Thanks
I think this is caused by floating point imprecision.
Try changing your data type to a currency type, seeing as how you're apparently working with money:
Rather, you ought to do this at the query level, changing the data type to a fixed decimal type, which you ought to be doing anyway when working with money (I'm unsure if the currency format changes your underlying data to a fixed decimal type; do this if the first option doesn't help):
4 Replies
I think this is caused by floating point imprecision.
Try changing your data type to a currency type, seeing as how you're apparently working with money:
Rather, you ought to do this at the query level, changing the data type to a fixed decimal type, which you ought to be doing anyway when working with money (I'm unsure if the currency format changes your underlying data to a fixed decimal type; do this if the first option doesn't help):
Try changing the Display Units setting on the card well from Auto to None.
Anonymous Use the Below mentioned DAX
Client Paid = FORMAT(SUM(Table1[Billed]),"00000")
Regards,
Chetan K
