KNOWLEDGE BASE

Showing Hawaii and Alaska Near Continental US


Published: 23 Apr 2013
Last modified date: 20 Jul 2023

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 colour 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 colour on the maps of Alaska and Hawaii as desired.
To view the steps shown in the below video, please expand the above section.
Note: the video has no sound.
 
CLICK TO EXPAND SOLUTION
(Optional) colour Formatting
(Video below) Set the colour from the sheet that you will duplicate.
  1. Go to the US Continental Sheet and click colour > Edit colours...
  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 colour 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 colour > Edit colours...
  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 shown 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 colour. An additional workaround has been posted in the Community Forums where the colour 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?