I tried mocking it up, but my data may not be representative of your true set up.
I think it should be doable with the dual axis, which will give you more control over the labels.
I also tried it with one axis and turned off the stack bars, but the labels got duplicated.
Yes, Reference bands would have been the most straightforward, were it not for the buffer space.
In Tableau 2018.3, you can make the chart background transparent:
Please see workbook v10.3 attached in the Forum Thread:
287275bars.twbx 1.2 MB
This is great and I thank you for the help.
I had two measures (the example above used only one: Sales).
Just a slight alteration and I got it to work
What I did:
- Union the data
- Created a "Table Name (Mod)" Calculations (Example: IF [Table Name] = "Orders" THEN 1 ELSE 2 END)
- Create a "Combined" measure (Example: IF [Table Name (Mod)] = 1 THEN [Sales] ELSE [Profit] END)
After that, the example above worked perfectly.
Glad that was helpful.
I like your approach with the union and the [Table Name (Mod)] calc.
All the best.