on 30 Jun 2017 04:15:56
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.
- Comments (5)
RE: Format count values with comma
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.
RE: Format count values with comma
Ignacio Orozco's solution worked perfectly for me! All the thumbs ups :)
RE: Format count values with comma
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... ;-)
RE: Format count values with comma
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.
RE: Format count values with comma
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 :)