KNOWLEDGE BASE

Pound Signs (###) Displaying Instead of Data


Published: 31 Oct 2013
Last Modified Date: 30 Jun 2017

Issue

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

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.

Cause

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