3 Replies Latest reply on Jan 27, 2014 6:29 AM by Prashant Sharma

Dual Axis with two sets of Measure Values

Howdy,

I am trying to make a dual-axis chart to overlay two sets of Measure Values.  I've built a small example workbook, posted below.

The first sheet shows the four measures I am interested in Sales, Profits, and then both of these restricted to items where the Unit Price is between 100-1000 (side note: I built the subset variables using the IIF() function - I could probably also do it using Sets, but I am not sure if that is a better or worse way to do it).

Now I want to use Dual Axis to overlay Sales 100-1000 on top of Sales and Profits 100-1000 on top of Profits.  I built a version of this in the second sheet.  Each of the two charts is essentially correct, however, what I can't figure out is how to make them be side-by side and to share a common y-axis.  It feels like a natural way to do this might be to create two sets of Measure Values - one with Sales and Profits and one with the subset variables - and dual axis one set on top of the other, but as far as I can tell that is not possible.  Any thoughts?

Thanks,

Craig

• 1. Re: Dual Axis with two sets of Measure Values

Hi Craig,

This is not doable without reshaping of your data. Here is the idea section for this: - http://community.tableau.com/ideas/1498

Here is some good discussion on this: - Two independent "Measure Values" pills on dual axis chart?

Dual Axis with two measured values on each Y axis

Warm Regards,

Prashant Sharma - India | LinkedIn

• 2. Re: Dual Axis with two sets of Measure Values

Hi Prashant,

I have actually looked at those threads, but it wasn't clear to me that the re-shaping examples were directly applicable to my current need.  In those examples, people were essentially making a single chart with multiple measures on each axis (i.e. one x-axis with a dualed y-axis).  I need to have multiple x-axis, each of which is sharing a y-axis, and each with its own dual-y-axis variable.

At worst, I figure I can build each subplot individually and mash them together into a dashboard, but that obviously has some major drawbacks.

• 3. Re: Dual Axis with two sets of Measure Values

Hi Craig,

I do not think that this is possible. But your thought of putting them together in a single dashboard is fine & may be the only method. But may be someone from community may help into this.

Warm Regards,

Prashant Sharma - India | LinkedIn