Forum Discussion

Helper I

9 years ago

Data Labels Display Units

I have a bar chart with data labels. When I set the display units to Auto, the chart just gives the numbers as one long string with no commas, no M, no K, no formatting. I have a slicer that when a d...

Solution Supplier

9 years ago

Hey Rylee,

I would look at your data types. Below, the column "Net Worth" is a Fixed Decimal Number which usually is currency. The Column "Net Worth Number" is selected and you can see the Data Type is Decimal Number and I have selected the Thousands Seperator under the Modeling tab.

Hope this helps,

Alan

Rylee
Helper I
9 years ago
Thanks for the response, but here is an image of my issue. I have my labels set to "auto" assuming it will show up as 25.91k or 25,914 for thousands and change when the number is in the millions or billions, but the "auto" option is instead leaving the units unformatted.
- alanhodgson
  Solution Supplier
  9 years ago
  Hey Rylee,
  
  I understand the issue, but I am just unable to replicate it. I think it is how your data is formatted. The column you are using in the "Values" section of the bar chart, is it a calculated column or a measure? And what is the Data Type of that column/measure (Whole Number, Decimal, Fixed Decimal, etc.)?
  
  Best,
  
  Alan
  - alanhodgson
    Solution Supplier
    9 years ago
    Rylee,
    
    I was able to replicate your problem. Looks like you might have found a bug in the visual. It worked fine when using the "Column Chart", but if you use either the Stacked or Clustered "Bar Chart", then the K/M won't show up. I was able to get a thousands seperator to work for the bar chart. See below (Added a bunch of columns with different data types to make sure it wasn't just one date type messing up):
    
    Cheers,
    
    Alan

Related content