Tableau Community Forums

Here's one option for coloring--you can drag multiple fields to the color shelf by holding the SHIFT key.  This creates a unique color for each combination of gender/ethnicity, but it may work in this instance.

As far as labeling each side of the axis, this cannot be accomplished by editing the axis since its really only one axis now.  You could work around this by placing text boxes below each side of the axis, and positioning things carefully within dashboard containers so it all lines up nicely.

Hope this has helped. See attached for coloring I set up--there may be other ways to accomplish a better color scheme.

Yes, I believe that was for labeling the marks like in the attached--the marks show as positive numbers with that custom format.

Yes, well, the setup he uses is different from this one, too.  He has one calculation that determines male or female, and gives a value of 1 or -1, based on whether they're male or female.  You'd have to set up your view the same way to use the same techniques he used.

If i can jump in and propose a solution to the original question;

- You can bring  a negative copy of the female count on the column shelf at the right of the Male Count.

- Set the color transparency at 0%

- Make it dual-axis with the Male Count and synchronise Axis.

Michel

You can also do it with invisible reference lines on each axis, with this calc:

IF COUNTD([Person Female] )>COUNTD([Person Male] ) THEN COUNTD([Person Female] )

ELSE COUNTD([Person Male] ) END

(See attached)

--Shawn

Nice solutions by both of you--thanks for sharing!