KNOWLEDGE BASE

Showing Hawaii and Alaska Near Continental US


Published: 23 Apr 2013
Last Modified Date: 14 Aug 2017

Question

How to display Hawaii and Alaska near the continental United States.

Environment

Tableau Desktop 

Answer

CLICK TO EXPAND SOLUTION
Create Separate Maps

Follow along with the attached sample workbook.

Step 1: Create separate maps for the continental United States, Alaska, and Hawaii

  1. Double-click State to create the view.
  2. Drag Sales to Color on the Marks card.
  3. Right-click the worksheet tab and then select Duplicate Sheet.
  4. Repeat Step 3 so that there are three identical map views.
  5. Name the first worksheet "Continental US." 
  6. In the Continental US worksheet, drag State to the Filters card.
  7. Clear Alaska and Hawaii and then click OK.
  8. Click on the next worksheet tab and name it "Alaska."
  9. In the Alaska worksheet, drag State to the Filters card.
  10. Click the None, select Alaska and then click OK.
  11. Click on the last worksheet tab and name it "Hawaii."
  12. Drag State to the Filters card.
  13. Click None, select Hawaii and then click OK.

Step 2: Create a dashboard with a floating layout

  1. Drag the Continental US worksheet onto the dashboard.
  2. Under Add new sheets and objects, click Floating.
  3. Drag the Alaska and Hawaii worksheets to the dashboard.
  4. Re-arrange, re-size, and adjust color on the maps of Alaska and Hawaii as desired.
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.
 
CLICK TO EXPAND SOLUTION
(Optional) Color Formatting
(Video below) Set the color from the sheet that you will duplicate.
  1. Go to the US Continental Sheet and click Color > Edit Colors...
  2. Click the Advanced>> button
  3. Manually set the range of your measure.
  4. For example, we notice that Sales go from approximately 10926 to 1372210.
  5. When building the rest of your sheets, the color range will be applied automatically.
Alternatively, if your dashboard is already built, simply follow the steps below:
  1. Go to the US Continental Sheet and take note of the range of the measure.
  2. Go to the Alaska and Hawaii Sheets and click Color > Edit Colors...
  3. Click the Advanced>> button
  4. Manually set the range of your measure.
  5. Repeat steps 2 to 4 for the Hawaii sheet.
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.
 

Additional Information

The data related to Alaska and Hawaii in the Superstore sample data source is the same (1,004,982.94 dollars Sales); both Sales data correspond to the same purchase in the underlying data. Therefore, you will not be able to differienciate their color. An additional workaround has been posted in the Community Forums where the color is adjusted from a range from 0 to 1. Please see the attached workbook in this post for more information.
Did this article resolve the issue?