Card Visualization number format

[EMyrta]

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 ?  

[ryan_mayu · Accepted solution]

@EMyrta 

please try the settings in measure tools

[westwrightj · Accepted solution]

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

[EMyrta]

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! 🙂

[ryan_mayu · Accepted solution]

@EMyrta 

please try the settings in measure tools

[EMyrta]

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 🙂