Number Format in Matrix: Column Header

[comish4lif2]

I have a numberic field that contains counter data. Data that is a count of things and the values in that field are all whole numbers (1-12).

In some of the visualizations, that data is depicted as an average of that data and of course is sliced in many ways. As such, the values I wish to see displayed is 1.26, 3.78, etc., for example on a filled map.

But, in a matrix visual, if I use that field as column headers, I would want to see only the whole number - no decimal. 

So, here's my comment and question, I cannot change the decimal/number display in the matrix column header, so, I have the Counter field set to whole number and 0 decimal places. I can manually set the decimals in most (but not all) visualztions. But, If I use the map, and drop the average of the counter as a tooltip, it shows as a whole number (3 and 3.48).

Am I correct that I cannot change the number display format everywhere - and specifically in these 2 places?

[OwenAuger · Accepted solution]

Hi @comish4lif2

I believe you can solve this by creating explicit measure(s) with the number format set appropriately, 

1. Specify the number format for the numeric column itself, which will be applied whenever that column is used on the axis of a visual, such as a matrix column header (I believe you have already done this)
2. Creating explicit measure for any aggregations of that column, such as 
   Average of Column = AVERAGE ( Table[Column] )​
   and specify an appropriate number format for the measure, such as 2 decimal places.

This way, you should be able to avoid having to use visual-level settings to override the number format (certainly for built-in visuals).

Regards,

Owen