Try dragging the Region AND Units pills onto the color shelf at the same time - that's worked for me in the past.
I tried it before, did not worked
I just had a chance to try the example connected to the link I had posted (Thanks to Matt Lutton and Luciana Suran for working it out in the original post) .
There is also another link that explains the process in detail:
The idea is to create a 'dual axis', using your measure. The first axis will have Category for the color. The second axis will have your measure as the color.
Once you've done that, all you need to do is click on 'color' on the marks shelf of the second axis and turn the transparency to approximately 65%.
I've recreated an example for you to take a look at.
Hope this helps.
Just curious, did you place 'Region' on the color shelf of the first dual axis? It looks like you've placed the sales on the second.
I checked your first link earlier today and did everything like there. Also downloaded this Coloring by Dimension AND a Measure ML example.twbx from that thread and tried to reproduce viz myself. But couldn't
3 of 3 people found this helpful
Ok. It could be a case of the order pills are placed. Let's try it step by step: (this is how I had recreated it)
Start by placing 'Sales' on the Rows shelf, then 'Region' and 'State' on the Columns shelf.
Next, place 'Region' on the Colors shelf. At this point your Regions should all have their own individual colors, along with their corresponding States.
Now place another 'Sales' pill on the Rows shelf, click the drop down arrow and select 'dual axis'.
Change the main Marks to 'Bar'.
You'll now see on the Marks shelf that there are 2 - 'SUM(Sales)' and 'SUM(Sales) 2'.
If you click where it says 'SUM(Sales)' at the bottom of the Marks shelf, you'll notice that 'Region is still on the Colors shelf.
Now click on 'SUM(Sales) 2'. Drag and drop another 'SUM(Sales)' pill to the Colors shelf on that Marks shelf.
Click on the Colors shelf of 'SUM(Sales) 2' and change the Transparency to anywhere between 40% - 50%.
Finally, it should look like this:
Let me know if this explanation helped out.
Thank you, Don, so much for your comment.
But still, I couldn't reproduce it. I'm using T10, but I don't think that this is the case. I will update to newest T10.1 and will download T9.
I followed instructions few times, this is what I got every time.
The region still the color.
I will let you know after I try it in T9
Ok. Here's something you can try:
Click on the drop down arrow (top right corner) of the gradient legend.
Select 'Edit Colors', then choose 'Custom Sequential' from the drop down under Palette.
Click on your current color and then select Black.
This should help.
Your current color might be effecting how the colors show through.
Give it a try. I have a copy of Tableau 10. I'll try it there, just in case there a glitch with the new version.