Forum Discussion
Thousand separator
- 6 years ago
Not @mpavillard,
He did not refer to it being a text value. In that case, create a measure like the following and create the format of the field.
MEasure = COUNT(TAble[Columna])
Hi mpavillard ,
That has to do with the formatting, select the column or measure then go to the columns/measure options and activate the comma:
- MFelix6 years agoSuper User
Hi mpavillard ,
You are using the previous version of the ribbon on the modeling tab when you select a column the option appears.
- mpavillard6 years agoRegular Visitor
But it's greyed out, I can't select it. I think it's due to the fact that the data type is Text, but I can't change it, because it's actually a count of records of a text field, so that's correct.
If I try to change it to Whole number, I get the following error:
Imagine this was a list of cities, and I wanted to know the number of cities in a certain country. That of course would be a count and would return a number, but the data is actually text. Why can't I format that count?
- MFelix6 years agoSuper User
Not @mpavillard,
He did not refer to it being a text value. In that case, create a measure like the following and create the format of the field.
MEasure = COUNT(TAble[Columna])