(Version 9.2 workbook)
You'll need to generate both amounts in one sheet to be able to compare them.
Before moving forward, consider what I did in Sheet 4 in the attached. It's a way to put both sets of numbers in one sheet. This might be enough to get you going, but if this approach works and you can't get the next steps to work, let's talk about what to do next.
Two Bar Chart Comparison 2.twbx 1,007.8 KB
Thank you so much for the suggestion, I think this is a great way to present.
My only left issue is how could I conditionally color format the bar charts. If it is just to compare the Avg.Profit, then I can create a calculated filed, something similar to Avg(Profit) > WINDOW_AVG(avg(Profit)) and drag it to the color marks. But now in my case I am targeting at the selected "Measure Values" and I can not do Avg(Measure Values) > WINDOW_AVG(avg(Measure Values)) in Tableau. Is there a workaround you can come up with regarding this issue?