Matrix Conditional Formatting

[dchoward]

Is it possible to format the agregated number with comma "," in a Matrix count and sum or any other agregation? 

[Greg_Deckler]

Generally you do that in the data view, just click your measure or column and specify the formatting in the ribbon such as commas, decimal places, etc.

[dchoward]

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.  Not sure how I would be able to format that within a data view when widgets isn't a number.  Not finding anywhere to change the format.

[kiltannen]

@dchoward - Did you ever get an answer to this issue?

I am trying to do the same thing and can't find it anywhere.

[dchoward]

No, I was never able to format the record count.  Have been living with the default without any commas. 

[v-sihou-msft · Accepted solution]

@dchoward

You can click on the field, unlselect the thousand separator under Modeling tab.

Regards,

[dchoward]

This solution does not do want I need.  The count function in a table on a text field does not allow selecting Formatting.  Here is an example of the table I like to add comma's in the count column.