Forum Discussion
Card Visualization number format
Hi,
I have noticed when using Card visualization, the number can not be formated even though i try to format it in the data lables options. Example as below, even though the format can be "Millions", or "None" or "Auto" , or round the decimal places with "0", the number will stay with an unusual format. Normaly it should show "0" cause the number is very small.
Is this a bug of current version? Is there a way to work around it ?
Hey EMyrta,
It looks like there a few things you can do. So I've made a test that started like this
One option is to just change the number of decimal places to "0" and choose a different format display like this
If you are using things within a measure you can change your digits into text with the FORMAT function
Max Value = FORMAT(MAX('Table (2)'[Test]), "###,##0")Which gives you the same result
Let us know if that solves your problem
4 Replies
Hey EMyrta,
It looks like there a few things you can do. So I've made a test that started like this
One option is to just change the number of decimal places to "0" and choose a different format display like this
If you are using things within a measure you can change your digits into text with the FORMAT function
Max Value = FORMAT(MAX('Table (2)'[Test]), "###,##0")Which gives you the same result
Let us know if that solves your problem
Hi,
Thanks for providing two work around this! The first one is a good solution in my cause cause i have a calculated Measure as value in the card. As for the second one by it requires a column to perform such formating with the formula.
Thanks for quick reply! 🙂
Hi Ryan,
Thanks for the fast reply, actually your solution is a good work around this issue. The value that i put the in the card is a calculated measure, so formating the measure as decimal number with zero decimal places and changing the format of data lable from "Millions" into "Auto", allows me to display better the value of the card, compared to previously.
The only thing is that i lose the fomat "Millions", which is required to be mainted throughout the file for reporting purpose, but at least its better than before.
Again thank you for quick support! It is much appriciated 🙂
