7 Replies Latest reply on Oct 24, 2016 4:52 AM by Jonathan Drummey

# 3 Filled Colors on a Dual Axis Map?

Hi Everyone!

I have two maps one colored with a dimension and the other a measure.  I know how to create a dual axis map and layer these colors on top of each other, but the result is a muddy map.

I do know that in other viz types depending on the circumstance you can add a pill to the detail marks card and then add it as a secondary color.

Any thoughts?

Dimensions map           +        Measure Map             =          Muddy Map

• ###### 1. Re: 3 Filled Colors on a Dual Axis Map?

Thanks for the detailed explanation of what you know. Please explain (mock-up) what it is you are looking for. Thx!

--Shawn

• ###### 2. Re: 3 Filled Colors on a Dual Axis Map?

You may want to try coding a calculation to allow 2 discrete options from your measures map. (i.e. Above a certain # or below a certain #.)

And then just pick the colors you want based on the three colors you hope to see on the 'Muddy Map'. That should provide you a three color final map.

• ###### 3. Re: 3 Filled Colors on a Dual Axis Map?

I agree with John. You're really not looking for a continuous color, you are looking for a 3-color dimension: Red, Blue, Purple, which can be created by a calculated field. But if you are also looking to 'control' or 'affect' the intensity of the color, then (as far as I know) Tableau does not support this sort of combination of discrete & continuous colors; at least without getting what you consider 'muddy'.

--Shawn

• ###### 4. Re: 3 Filled Colors on a Dual Axis Map?

Hi Benjamin,

The best one could usually do is

and setting both maps Transparency as needed.

But if one strives for perfection and demands vivid colours,

there's no way other than making Data Blend

using a hand-made "Scaffold" Primary datasource

comprised of all Dimensions necessary for a map view,

including the hard-coded Sales Bins.

Hope it could help a bit.

Yours,

Yuri

• ###### 5. Re: 3 Filled Colors on a Dual Axis Map?

I've got a solution that will get vivid colors, I'm doing a writeup on it that will be ready on Monday.

• ###### 6. Re: 3 Filled Colors on a Dual Axis Map?

Patiently waiting.

• ###### 7. Re: 3 Filled Colors on a Dual Axis Map?

Here you go... I created an ad hoc group of red states & blue states and then colored each set of them by the % of Total Sales where the lightness of the two color ramps is symmetrical so we can accurately compare across red & blue.

I documented several methods for this sort of coloring, there are two that can exactly achieve this result, and did a big writeup on this. See Two Sequential Color Palettes on the Same Map: Coloring by a Dimension and a Measure | Drawing with Numbers, here's a link to the workbook: Two Sequential Palettes on a Map.

Jonathan

1 of 1 people found this helpful