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

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

EMyrta 

please try the settings in measure tools

 

EMyrta's avatar
EMyrta
Regular Visitor
6 years ago

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 🙂