I came across an old post with some replies that might be of use. One talks about using a Dual Axis, then the other talks about turning Stack Marks off.
Could you please let us know if either of these options work for you?
It could depend on how your data is set up, but it should be do-able, are you able to share a workbook?
Hey Guys, thanks for the replies!
I forgot about Stack Marks Ciara! I'm not sure that solves the issue as I believe i'm still stuck on how to get dual axis + dual measures but I think it might help in the solution as I have a feeling I need to be using a pivoted source.
Hey Chris, I've attached the workbook. I've just removed some extra columns of dimensions and measures from the source that weren't relevant but pretty sure shouldn't impact solution.
EDIT - I think I've worked it out... Need to pivot the data and make calculated fields.
Needed to make two calculated fields using IF statements on the single pivoted measure.
First calculated IF statement to pick This Year 2018 A + B category orders.
Second calculated IF statement to picked Last Year 2017 A + B category orders.
Doing this gets around the multiple measure issue if the data isn't pivoted.
Then just drag the each of those calculated fields onto dual axis.
Still looking a bit busy... I need to make running averages on everything to smooth it out and show the trends but get the idea
Thanks All! Ciara, that was helpful, made me start thinking more!
Dual Axis Stacked Bar Area.twbx 266.1 KB
You're so welcome Josh! Glad its sorted