Dashboard sizing options in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows the three main dashboard sizing options in Tableau with their descriptions.

Cell	Value
A1	Dashboard Size Option
A2	Fixed Size
A3	Automatic
A4	Range
B1	Description
B2	Set exact width and height in pixels
B3	Adjust size to fit the screen or container
B4	Set minimum and maximum size limits

Formula Trace

Dashboard Size = IF option = 'Fixed Size' THEN set width and height ELSEIF option = 'Automatic' THEN adjust to container ELSEIF option = 'Range' THEN set min and max size

Step 1: option = 'Fixed Size'

Step 2: IF option = 'Fixed Size' THEN set width and height

Step 3: ELSEIF option = 'Automatic' THEN adjust to container

Step 4: ELSEIF option = 'Range' THEN set min and max size

Cell Reference Map

  A               B
+----+------------------------------+
| A1 | Dashboard Size Option         |
| A2 | Fixed Size                   |
| A3 | Automatic                   |
| A4 | Range                       |
+----+------------------------------+
| B1 | Description                 |
| B2 | Set exact width and height  |
| B3 | Adjust size to fit container|
| B4 | Set min and max size limits |
+----+------------------------------+

Cells A2 to A4 contain the sizing options. Cells B2 to B4 describe each option. These feed into the sizing logic.

Result

  A               B
+----+------------------------------+
| A1 | Dashboard Size Option         |
| A2 | Fixed Size                   |
| A3 | Automatic                   |
| A4 | Range                       |
+----+------------------------------+
| B1 | Description                 |
| B2 | Set exact width and height  |
| B3 | Adjust size to fit container|
| B4 | Set min and max size limits |
+----+------------------------------+

Result: Dashboard size changes based on selected option.

The dashboard size changes depending on the selected option: Fixed Size sets exact pixels, Automatic fits container, Range sets limits.

Sheet Trace Quiz - 3 Questions

What happens when you select 'Fixed Size' for the dashboard?

A The dashboard size is set to exact width and height in pixels.

B The dashboard automatically adjusts to the screen size.

C The dashboard size varies between minimum and maximum limits.

D The dashboard size is ignored.

Key Result

Dashboard sizing uses conditional logic to apply Fixed, Automatic, or Range size settings based on user choice.