Thousands separator on "count" column in Matrix

[kiltannen]

When creating a visualization of a "Matrix" and I select a column to use as my "Values", and then I select "Count" (number of widgets), it displays the count without commas breaking up the thousands.  

I have tried creating a measure

WidgetTypeCount = count([WidgetType])

that I could then select thousands separator on the modelling featureset - but I was not able to put this measure in the "Columns" space on the Matrix properties.

Does anybody know of a way to do this?

[Anonymous]

WidgetTypeCount = COUNTA([WidgetType]) if you are counting text values, it works, not

WidgetTypeCount = count([WidgetType])

[Anonymous]

HI @kiltannen,

>>that I could then select thousands separator on the modelling featureset - but I was not able to put this measure in the "Columns" space on the Matrix properties.

Nope, current matrix not support use measure in row and column field.
You can try to use column in value field with summary mode 'count', then turn on the thousand separator option on modelling tab.

Regards,

Xiaoxin Sheng

[Anonymous]

yes you are right. I tried  to do that but what if column contains text value and I am using count of that column then how can I apply comma in that situation.

[Five5tring]

Hey,

Sorry if I'm a little late to the party, but I was searching for this exact issue, but then managed to find a way to fix it by myself completely by chance.

Select your matrix and go to "Format your visual".
In the "Visual" section, choose "Specific column" and then select the column you want the thousand separator in.
Add a decimal place in "Value decimal places" then revert it to 0 (not auto).
There should now be a thousand separator.

[Anonymous]

Thousands separator is NOT displayed on a column that is summarized as count.

The only way to achieve it is to use a measure - however, as pointed above, you can only use the measure as matrix values.

It would be a great improvement if formatting options work regardless of summarization type.