Tableau Course
Layout and Formatting
Layout controls how objects are positioned and sized on a dashboard — tiled vs floating, containers, padding, and spacing. Formatting controls how each visual element looks — fonts, borders, shading, gridlines, and tooltips. Together they determine whether a dashboard feels polished and purposeful or cluttered and accidental.
Tiled vs Floating Objects
Every object placed on a Tableau dashboard is either Tiled or Floating. This is the most fundamental layout choice and it affects everything else about how the dashboard is structured.
To switch an object between tiled and floating: select it on the dashboard, open its object menu (grey caret at the top right of the tile), and choose Floating or Tiled. You can also hold Shift while dragging a new object onto the canvas to place it as floating immediately.
Layout Containers
A layout container is a grouping object that holds multiple sheets or other objects and arranges them automatically. There are two types — Horizontal and Vertical. Objects inside a horizontal container sit side by side. Objects inside a vertical container stack top to bottom. Containers are the primary tool for building structured dashboard grids.
Containers can be nested — a horizontal container can sit inside a vertical container, and vice versa. This nesting is how complex multi-row, multi-column grids are built. To add a layout container: drag a Horizontal or Vertical container from the Objects panel on the left of the dashboard workspace onto the canvas. Then drag sheets into the container.
Padding — Inner and Outer
Padding is the white space around and inside objects on the dashboard. Tableau controls padding at two levels for every tiled object and container.
| Padding Type | Location | Effect |
|---|---|---|
| Outer Padding | Space between the object's border and surrounding objects | Creates breathing room between chart tiles — prevents charts from pressing against each other |
| Inner Padding | Space between the object's border and the content inside it | Prevents chart content from pressing against the tile edge — makes text and marks more readable |
To adjust padding: select an object on the dashboard, then open the Layout tab in the left panel and expand the Outer Padding or Inner Padding section. Each side — top, right, bottom, left — can be set independently or linked to apply the same value to all four at once.
The Layout Tab — Position and Size Controls
The Layout tab in the left panel — visible when any dashboard object is selected — gives precise numeric control over that object's position, size, and padding. This is especially useful for floating objects that need to be pixel-accurate, and for aligning two objects to the exact same size.
| Control | Purpose |
|---|---|
| X / Y position | Pixel coordinates of the object's top-left corner from the canvas origin. Used to align floating objects precisely. |
| W / H (width and height) | Exact pixel dimensions. Set identical W and H values across two objects to make them the same size. |
| Inner Padding fields | Top, right, bottom, left padding inside the object border — space between the tile edge and the chart content. |
| Outer Padding fields | Top, right, bottom, left margin around the object — space between this tile and adjacent tiles. |
Dashboard Size Settings
The overall canvas size is set in the Dashboard tab in the left panel under the Size section. Choosing the right size mode is one of the most important layout decisions because it determines how the dashboard behaves on different screens.
The Format Menu — Three Levels
Tableau's formatting system applies at three levels that cascade from broad to specific. A setting at a higher level applies everywhere unless overridden at a lower level.
The Format Pane — Sheet Tab
The Sheet tab of the Format pane is the primary formatting location for most visual changes. It is divided into three columns — Sheet, Rows, and Pane — each with sections for Font, Alignment, Shading, and Borders.
Gridlines, Axis Lines, and Zero Lines
Gridlines, axis lines, and zero lines are controlled through Format → Lines. Each can be set independently to a style, colour, and weight. The goal is to keep reference lines light enough to be useful without competing with the data marks.
| Line Type | Purpose | Recommended Setting |
|---|---|---|
| Grid Lines | Horizontal and vertical guides at axis tick marks — help the eye trace a mark to the axis | Light grey, 1px solid. Remove entirely for bar charts where value labels are shown. |
| Zero Lines | The line at zero on an axis — separates positive from negative values visually | Medium grey, 1–2px. Keep visible whenever the data crosses zero. |
| Axis Ruler | The line that runs along the axis itself | Light grey or none — axis labels make the position clear without a heavy line. |
| Reference Lines | Added via the Analytics pane — show trends, averages, or thresholds | Dashed, medium weight, colour distinct from data mark colour. |
Number and Date Formatting
Number formats control how measure values display on axes, labels, and tooltips. Right-click a field on a shelf → Format → Numbers section. Tableau provides built-in formats and a Custom option using standard format codes.
| Format | Displays As | Custom Code |
|---|---|---|
| Currency | $1,234,567 | $#,##0 |
| Currency abbreviated | $1.2M | $#,##0.0,,\M |
| Percentage | 34.7% | 0.0% |
| Thousands | 1,235K | #,##0,\K |
| Positive / Negative | ▲ 12.4% / ▼ 3.1% | ▲0.0%;▼0.0% |
Tooltip Formatting
The tooltip is the popup that appears when a viewer hovers over a mark. By default Tableau populates it with every field in the view — which is usually too much. To edit: Marks card → click Tooltip. Type free text, insert field values with the Insert button, format numbers inline, and remove any fields the viewer does not need.
Hiding and Clearing Formatting
| Element | How to Hide or Remove | When to Do It |
|---|---|---|
| Axis title | Right-click the axis → Edit Axis → clear the Title field | When the chart title or data labels make the axis title redundant |
| Field label | Right-click the label → Hide Field Labels for Rows/Columns | When field names like "Sub-Category" are obvious from context |
| Header row | Right-click a header → Show Header (uncheck) | When values are already shown as data labels on marks |
| All custom formatting | Format → Clear Worksheet Formatting | When formatting has become inconsistent and you need a clean baseline |
| Sheet title | Worksheet → Show Title (uncheck) | When the sheet sits inside a dashboard that provides its own title context |
Layout and formatting are separate concerns — get the layout right first, then apply formatting. If you start formatting before the layout is stable, you redo that work every time you move a tile. Start every new chart by clearing all default formatting via Format → Clear Worksheet Formatting, then deliberately add back only what is needed. Gridlines on a bar chart with value labels: remove them. Zero line on a chart that crosses zero: keep it. You will be surprised how little formatting a clean chart actually needs.
Practice Questions
1. A dashboard needs three KPI tiles in a row at the top and two equal-width charts below them. Which layout container structure achieves this and how are the containers nested?
2. Charts on a dashboard are pressing against each other with no spacing. Where in Tableau do you control the gap between tiles, and what are the two types of padding involved?
3. A Sales axis is showing values like 1234567.83. How do you format it to display as $1.2M — which level of formatting is this and where is it applied?
Quiz
1. Two sheets need to be stacked on top of each other in the same canvas zone for a sheet-swap pattern. Which object placement mode makes this possible?
2. A self-service dashboard will be viewed on screens ranging from 1024px to 2560px wide. Which dashboard size setting gives the best responsive behaviour?
3. A workbook-wide number format shows integers, but one specific measure on one specific sheet needs two decimal places. Which formatting level handles this and how is it accessed?
Next up — Lesson 46: Mobile Dashboards — designing for small screens using device-specific layouts, the mobile preview mode, and responsive sizing strategies.