I want two have a graph that has a stacked bar chart with two or more measures that corresponds to the left axis, and at the same time a 'stacked' line graph with two or more measures (each a separate line) on the separate right axis (different scale). I know it's easy to do the first part, and to put one measure on the right axis, but I can't figure out if there's a way to do a dual axis chart using two independent measure values pills.
The only way I can think this would work would be to have two measure values pills on the rows, but I don't see any way to filter them independently so the left axis one represents bar chart variables A and B, while the right axis one represents line chart variables C and D.
Any ideas? I can't believe there's no way to do this.