Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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):
In the card formating pane make display unit as Auto.then it work
@Anonymous Use the Below mentioned DAX
Client Paid = FORMAT(SUM(Table1[Billed]),"00000")
Regards,
Chetan K
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |