KNOWLEDGE BASE

Full Data in View or Export Data Does Not Match Formatting of Fields in the View


Published: 30 Nov 2016
Last Modified Date: 21 Dec 2016

Issue

When you use View Data or Export Data and choose Full Data, formatting does not match the formatting of fields in the view.
 

Environment

  • Tableau Desktop
  • Tableau Server
  • Tableau Online

Resolution

Set the desired format for the field in Full Data using Default Properties. 
Note: this will also affect any view that does not have sheet-level formatting explicitly applied.

  • Right-click on the field in the Side Bar and select Default Properties > Number Format (or Date Format). 

To apply a formatting other than the default to the field, use Sheet Format:

  • Right-click on the field anywhere in the view (such as Rows, Columns, Text, etc.) and select Format... 

Cause

Formatting set using Default Properties affects all worksheets that do not have Sheet Format applied, and controls the format of Full Data regardless of the Sheet Format. Sheet Format controls the formatting of the field in an individual view.

 

Additional Information

To correct the issue in a published workbook, follow the resolution steps in Tableau Desktop and then republish the workbook.
Did this article resolve the issue?