I am stuck with a problem that I can't seem to get working. I am building a view that shows Stacked bar chart (by displaying 3 Measures stacked) for a Dimension. This I can achieve easily since data is coming from same source. I now have to add 2nd Data Source that contains 1 measure - this I need to Show in the view as single bar. Now for the problem part the Stacked bar from previous and this single bar needs to be show across same Dimension as a Side by Side chart.

I have attached a sample workbook with both data sources.

Any help or input on how to achieve this? Below is sample image of final result expected.

Please explain how it does not help. It's about as close as you'll come, given your data sources and structures. If it's close, provide a visual mockup of EXACTLY what you want, and how it differs from what I provided. There is no way to stack some bars, and leave others unstacked, without separating into two axes, like below

Getting exactly what you want may not be possible, but the workaround will either be what is posted above or what is pasted here or below. The screenshot you posted is not going to be possible with the data you have provided.

Any other approach(es) will require re-structuring and possible combining your data sources.

I do not believe so, not without separating onto two sheets, and using a dashboard to somehow make things line up. If you create a single source, I'll take another look at what's possible.

Sometimes, though, its just easier to work with an alternate that does work inside Tableau -- you may get some push back, but as long as the message is communicated well, I think you should be able to make an alternate layout work. After all, the data is the same either way.

Matt Lutton - I agree on your point. I am able to show all 4 metrics on a stacked bar chart to convey the message. Ideally the other view would be great to really show the impact of 3 measures in stacked vs single bar on a Side-by-Side comparison - would be nice feature to have. Will check in Ideas to see if anyone has submitted something.