Is that possible to be have two bar charts but not stacked? Something like the picture I posted?
Unfortunately, from what I know, the only way to achieve that is the way you did, using Measure Names and Measure Values, but they will use the same axis.
How do I create bar chart + line chart like you shown to me?
Sure, here are the steps:
1. Add both measure on Rows.
2. Select dual axis on the second measure:
3. Select on the marks card, the 3rd tab and change it to Line.
This is the final result:
If this solves your post, please mark it as Correct Answer.
BarLines_v2018.1.twbx 1.2 MB
1 of 1 people found this helpful
Eduardo has correctly explained the steps for creating a dual axis chart. This would work
well in your case since one measure is much smaller than the other and you will be able to see
it for all regions and compare which region does good/bad.
Since you did not have any dummy data, just by looking at your original chart, I made up
some dummy data for the Market Value and used very small random values for the Average
Submission Market Values. Here is what my visual looks like
Here we can see that ACS DS has a smaller Market Value (Bar) but has a higher Avg Submission
Market value. Hope this compliments the earlier solution that my predecessor has done. Hope this
Please mark Eduardo Moreno's solution as helpful and correct answer. Let me know if you have any
questions. Best Wishes !
Que tal ! Good job . Bueno !