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])

[v-shex-msft]

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

[Meet65020]

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.

[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.