Format Numeric Table Data Using the Table Context Menu

Numeric data and date formats are set at the source. You can change them directly in a table or pivot table using the table context menu. Your format changes apply directly to that visual, and affects every instance of that visual in your dashboards, without affecting the underlying source formatting

Format numeric table data using the table context menu:

1. Select a table visual in a dashboard or in the Visual Gallery.
2. Locate the field in the table and select next to its column heading to access the table context menu.
   
   
3. Select Format <field> on the context menu. A Format work area opens. 
   
   
   
   Note: Select a Number Format, then select other options for this field. Select Apply to apply your changes to the data in the table column, or Reset reapply the source formatting.
   
   The other fields on the Format dialog change based on the Number Format you select.
4. Optionally, repeat for other fields in the table.
5. Save the visual, or the dashboard and visual.

Format aggregated data using the table context menu:

1. Select a table visual in a dashboard or in the Visual Gallery.
2. Locate the field that includes aggregated in the table and select  next to its column heading to access the table context menu.
   
   
3. Select Format <field> on the context menu. A Format work area opens.
   
   
4. Select the tab of the data you want to format: the aggregate data, shown here as Actualsales (Sum), or the raw data, shown here as Actualsales (Raw data).
   
   Note: You can apply different formatting options to your raw and aggregate data.
   
   
5. Select a Number Format, then select other options for this field. select Apply to apply your changes to the data in the table column, or Reset reapply the source formatting. Note: The other fields on the Format dialog change based on the Number Format you select.
6. Optionally, repeat for other fields in the table.
7. Save the visual, or the dashboard and visual.