Last Modified Date: 09 Jul 2018
- Tableau Desktop
- Microsoft PowerPivot
ResolutionIn Microsoft PowerPivot, change the number format of the column that you want to import as a measure to Decimal Number or Whole Number. For more information, see Set the Data Type of a Column on the Microsoft Developer Network (MSDN) and Set the data type of a column in Power Pivot in Microsoft Office Online.
CauseTableau does not detect measure formatting from Microsoft PowerPivot unless the data is formatted as decimal or whole numbers.
Additional InformationYou must apply decimal number or whole number formatting to every measure in the PowerPivot file that is formatted as a number in order to import the field into Tableau Desktop correctly.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials