-
1. Re: Label percent of total bar on a 2 measure stacked bar chart?
Catherine Rivier Jan 18, 2013 7:51 AM (in response to Sue Dietze)Hi,
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
Scope: Pane
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!
Catherine
-
per of bar question.twbx.zip 110.2 KB
-
-
2. Re: Label percent of total bar on a 2 measure stacked bar chart?
Sue Dietze Jan 18, 2013 9:18 AM (in response to Catherine Rivier)Hi Catherine,
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.
-
3. Re: Label percent of total bar on a 2 measure stacked bar chart?
Shawn Wallwork Jan 18, 2013 2:07 PM (in response to Catherine Rivier)Another BRILLIANT! Catherine. You're starting collect a lot of these.
--Shawn
-
4. Re: Label percent of total bar on a 2 measure stacked bar chart?
Thibault Reynier Jun 12, 2013 3:10 AM (in response to Catherine Rivier)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!
Thibault
-
5. Re: Label percent of total bar on a 2 measure stacked bar chart?
Shawn Wallwork Jun 12, 2013 4:23 AM (in response to Thibault Reynier)Pinging Catherine Rivier
-
6. Re: Label percent of total bar on a 2 measure stacked bar chart?
Sean Moore Oct 14, 2014 2:14 PM (in response to Sue Dietze)Also having the same issue with more than two measures. Can anyone help?
-
7. Re: Label percent of total bar on a 2 measure stacked bar chart?
Michael Lance Jul 13, 2015 11:36 AM (in response to Sean Moore)Me too. I wish Tableau allowed for more than 2 axes to be combined.