So first off, this is a fantastic sample workbook - thanks for putting it together, the detail is great!
The fact that you just have 2 measures stacked, and your calculated percentage fields, makes this solution work - see the attached.
To do this, I first moved your two calculated percentage fields into the Level of Detail, so I can use them in labels. Then I repeated Measure Values on a dual axis by re-dragging the Measure Values measure to the right-side Y-axis. I made sure "Synchronized Axes" was checked. (I also might uncheck "Show Header" for that axis to make it look exactly like your request, but I left it in now to make the solution easier to see.)
Then, under the Marks page, select "Multiple Mark Types" from the drop down. You can now scroll between Measure Values (1) and Measure Values (2). To set them up:
Measure Values (1):
Label: field [AO % Total Bkgs]
Marks to label: Min/Max
Field: Measure Names (this will pick the minimum alphabetical Measure Name)
Options: Uncheck "Label Maximum Values"
Measure Values (2): Same as above options, but with:
Label: field [Futs % Total Bkgs]
Options: Uncheck "Label Minimum Values"
Hope this works for you, please let me know if you have further problems with this!
per of bar question.twbx.zip 110.2 KB
Your solution is absolutely BRILLIANT!
Your explanation of it is fantastic too.
And now I’ve learned about a previously unnoticed drop-down menu (Label). Tableau continues to amaze and fascinate.
Thank you for the help.
Another BRILLIANT! Catherine. You're starting collect a lot of these.
Thank you very much Catherine for this great answer!
However, I currently dealing with more than two measure names, is it possible as well ?
I have noticed have the dual axis functionality for more than 2 measures... Do you know a way to do that ?
Thank you very much!
Also having the same issue with more than two measures. Can anyone help?
Me too. I wish Tableau allowed for more than 2 axes to be combined.