For your first question, it involves setting up a new sales variable (in the attached workbook, "Sales By Selected State"), that only counts sales for the state selected by the parameter.
IF ([State]=[State Selection]) THEN [Sales]
Then you can bring this in as a dual axis, and synchronize the axes. To have one be a bar, the other be a line, under Marks pull down to select "Multiple Mark Types". Then you can set Sales to bars, and Sales By Selected State to a line, or bar, or whatever you want. That's all in new sheet Market Sales NEW.
For your second question, I suppose I'm not completely clear why you set it up like a graph, so please let me know if you have a reason and I can take another stab. But in the meantime, the very simple way to set up your final chart the way you want is in sheet Multiple Marks - NEW (Simple). Is that what you're looking for?
Hope this helps!
Question workbook.twbx.zip 379.0 KB
Thank you for your help. The method you have is significantly easier than how I was setting it up for the second problem.