Forum Discussion

EMyrta's avatar
EMyrta
Regular Visitor
6 years ago
Solved

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 "Millio...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    EMyrta 

    please try the settings in measure tools

     

  • westwrightj's avatar
    westwrightj
    6 years ago

    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

westwrightj's avatar
westwrightj
Resolver III
6 years ago

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's avatar
EMyrta
Regular Visitor
6 years ago

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