Thanks for the reply Ernesto.
I just can't believe that soemthing so simple is not possible - especially when there is not a limitation placed on the number of measures plotted on the promary Axis.
Can someone from Tableau confirm that this is the case. Thanks.
I got some guidance on this from somebody pretty smart. He says you can't use multiple measure values pills. But you can have multiple measures on a dual axis, you just need to reshape your data.
Let's say you have data like this:
Date "A" type "B" type "C" type "D" type
1/1/2010 10 20 30 40
and you want A and B to be on the left axis, and C and D on the right axis. You need to end up with a dataset like this:
Date Axis one type Axis one count Axis two type Axis two count
1/1/2010 A 10 null null
1/1/2010 B 20 null null
1/1/2010 null null C 30
1/1/2010 null null D 40
Then you put sum(axis one count) and sum(axis two count) on rows, set dual axis, and then put Axis one type on the Color for axis one, and Axis two type on Color for Axis two, and then set marks to multiple and set each axis, if you want say, a stacked bar chart on the left and lines on the right.
I just rattled that off quick, not sure if it makes sense, but it works.
1 of 1 people found this helpful
What a workaround Ernesto!
I can confirm, Jeff, that it is not currently possible to place multiple measures on both the primary and secondary Y-axis. I would recommend putting a request under Ideas in the Community, as I know you're not the only person to request this!
Thanks for the confirmation Tracy.
Ernesto - You get a gold star for that nice workaround!! That will prove to be very useful until the functionality is added in Tableau to plot multiple measurement pills on the secondary axis.