Need to specify number of decimal places for an average in Matrix visualization (like in Bar Chart)

[Anonymous]

How can I specify the number of decimals to be displayed when performing an AVERAGE in the Matrix visualization?  The field is defined as a whole number.  The Chart visualizations provide a way to do this via Format tab -> Data labels, and set Decimal Places to 0, but the Matrix visualization does not...

Here's a Bar Chart with 0 decimals:

I need the Matrix view of the same data to be formatted the same:

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

In this scenario, you should be able to use the formula below to create a new measure to calculate the Average of Submission to Accounting Approval, then format the measure to whole number and show it in the Matrix visual instead. 

Average of Submission to Accounting Approval = AVERAGE ( 'Table1'[Submission to Accounting Approval] )

Regards

[Anonymous]

Is 'Average of Submission to Accounting Approval by Year and Quarter' a measure that you have defined?

[Anonymous]

"Submission to Accounting Approval" is the name of the column which is defined as a whole number.

"Average" is the aggregate function being applied via the Values field: