Like this? You said unstacked bar one over the other, so I'm assuming you want a stacked bar where you can actually see what part of sales is profit. The attached does. What I did was change the mark color for profit, then move its pill on the rows shelf to the right. Finally, synchronize the right axis.
If I'm confused, let me know and I'll try again.
stackedbars.twbx.zip 330.6 KB
This is what i am looking for. I tried to do the same way you did but "no luck".
This has been very useful. I have a related question -
I am trying to do a stacked bar chart as well, but I would like it to be additive.
I have two measures:
- Sum of Sales
- Calculated Field to show Increase in Sales
Currently, both measures are starting at the origin of the synchronized axis. I'd like it to display Sum of Sales in one color and then the Increase in Sales stacked on top of that, to show the potential gain based on the parameter setting.
Kevin - I'm assuming since you mentioned a parameter you are trying to show the increase in sales based on a user's input into that parameter probably as a percentage. Are these assumptions accurate? Second, is the projection ALWAYS an Increase, or do you need to be able to show the stacked bar if the user enters a decrease? I have a solution for both, but the option for a decrease makes it a little more involved. Not hard, just a few more steps.