KNOWLEDGE BASE

Pound (or Hash) Signs (###) Displaying Instead of Data


Published: 31 Oct 2013
Last Modified Date: 04 Sep 2017

Issue

When opening a dashboard in Tableau Reader or in Tableau Desktop, some data might appear to be replaced with "###" symbols.

Environment

  • Tableau Reader
  • Tableau Desktop

Resolution

Option 1

Resize the columns by placing the cursor over the border until a resize cursor appears, and then drag the columns until the expected data displays.

Option 2

Design the dashboard for the smallest anticipated resolution and then set the resolution to automatic after the worksheet has been built. Doing so allows the workbook to scale to larger resolutions while maintaining an appropriate design layout in lower resolutions.

Option 3

Right-click on the affected column and select Clear Manual Sizing.

Option 4

Use the ROUND function to round the numbers to a specified number of decimals, so that the numbers fit within the column. For more information, see Number Functions in Tableau Help.

Cause

The "###" displays instead of data when there is not enough space to display all of the data.
Did this article resolve the issue?