Per the Choosing the visual section earlier in this chapter, table and matrix visuals are good for looking up individual values and for displaying precise values. For example, all seven digits of the value $7,847,292 would be displayed on a table or matrix visual but this same value would likely need to be rounded to $7.8M in a column or line chart to maintain readability.

Table and matrix visuals support the same Display units and Value decimal places formatting properties as other visuals. In the following example from a table visual, both measures have been formatted to display their values in terms of millions with one decimal place:

 

Per the preceding example, these properties are available within the Field formatting card of the Format pane. Display unit options range from the thousands (K) to the trillions (T). By default, the Display units property is set to None for table and matrix visuals and thus displays the full value.

Prior to the availability of the Display units and Value decimal places properties, it was necessary to use the FORMAT() function in separate DAX measures to display custom formats in table or matrix visuals. The following two measures apply a custom rounded currency format to the results of the Internet Net Sales measure:

Internet Net Sales (Format Thousands) = FORMAT([Internet Net Sales],"$0,.0K")

Internet Net Sales (Format Millions) = FORMAT([Internet Net Sales],"$0,,.0M")