pbiideas1's avatar
pbiideas1
New Member
9 years ago
Status:
Needs Votes

Format count values with comma

When graphing a categorical/text field in a bar chart and displaying the count, allow the number to be displayed with a comma. Because the underlying field is text, the solution is not to change the format of the field.

7 Comments

  • I try to make a count of categories and when i select under the data label menu value decimals places as "0" the comma appear let me know if this fix your problem :)
  • I added a count measure .. like .. Count = COUNTA([364]) Then formatted the measure with commas and show that in the table instead. That's the only way I have found to do it.
  • I have the same problem formatting a COUNTed value. Even I count an integer or a text, I cannot format with thousand separator. It seems more like 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... ;-)
  • Formatting should be a simple thing to do. I also have an underlying text field that I am counting. Simply want to format the result on the chart with commas as the count values are large. When I create a measure and use COUNT the formatting to thousands does not work, when you SUM the value it works. Appears to be a bug.
  • When you right-click on a field and ask for COUNT to quickly add to the visual, it doesn't add a comma-separated value. That's the one thing that Tableau does better! A COUNT is by definition an integer, why not format it properly? #,##0?


    Thanks!

Recent ideas