Forum Discussion
Solved
Number Format in Matrix: Column Header
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 ...
Hi comish4lif2
I believe you can solve this by creating explicit measure(s) with the number format set appropriately,
- 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)
- 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
Hi comish4lif2
I believe you can solve this by creating explicit measure(s) with the number format set appropriately,
- 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)
- 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