Forum Discussion

Lucian's avatar
Lucian
Responsive Resident
7 years ago
Solved

Cannot format numeric value in data card visualization

Hello Everyone,   I have a problem formatting a number on a Data Card Visualization. The data came from an Access table, where I have a numeric field - "Order number" (in access is an autonumber, s...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Lucian,

     

    We can apply different formats to the values explicitly. Please refer to the snapshot below. 

    Cannot-format-numeric-value-in-data-card-visualization

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Lucian,

 

I just have the responses from the Product Team. It does work like that. The solution is using a measure. Thank you for reporting it.

 

Best Regards,
Dale

Lucian's avatar
Lucian
Responsive Resident
7 years ago

Hi Dale,

 

Thank you for your message, even though I agree that COUNT may be done over non-numeric columns, as long as the count is over "thousands", I would like to format it properly. Is like more a little bug or an omission from the development team, because as they thought to format it using different units, like thousands, millions and there they format it as 1,5K or 1,5M (with comma) there should be also an 1.500 without the need to create a separate measure for that... ;-)

It would be nice if they would include this as a "feature request" or improvement on the next release... ;-)

 

Kind Regards,

Lucian

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Lucian,

     

    I would suggest you vote up this idea.

     

     

    Best Regards,
    Dale

    • Lucian's avatar
      Lucian
      Responsive Resident
      7 years ago

      Hi Dale!

       

      Thank you for your suggestion. :)

       

      Kind Regards,

      Lucian