Matrix Visual- Grand Total Numbers to be formatted with comma

[shreyoogp]

Hi Everyone,

I wanted to know if there is any way we can format the Matrix visual Grand Total number as comma seperated numbers. I am displaying count(ID) in the visual for below rows and columns. I want to display the grand total or numbers with comma separator e.g. Grant total has 1978, which needs to be displayed as 1,978. How to achieve this.  I see Power BI new Feb version has no Field Formatting option and also i tried selecting the ID field from Field list, then under column tools formatting the ID field with comma, but Individual ID values in column gets the comma but not the Matrix visual, when tried dragging by using count(ID).

Appreciate your help greatly

Thank you

SGP

[MFelix · Accepted solution]

Hi @shreyoogp ,

Since you are making a use of a column and doing the count the formatting is not easy. Best way is to add a measure with the following code:

measure = COUNT(Table[ID])

Now format this has a numbe with the decimal separator.

[PaulDBrown · Accepted solution]

I take it you are using the Count function available in the field options. If you use a measure instead, you can format the measure to display the values as comma separated numbers.

The measure would be:

Count ID = COUNT(table[ID])

You then format the number under the options in "Measure Tools"

[shreyoogp]

@MFelix  : Thank you so much. It worked

[MFelix · Accepted solution]

Hi @shreyoogp ,

Since you are making a use of a column and doing the count the formatting is not easy. Best way is to add a measure with the following code:

measure = COUNT(Table[ID])

Now format this has a numbe with the decimal separator.

[shreyoogp]

Thank you so much. It worked