As far as I know, there's no way to do this using Measure Names/Values. The thread you linked to shows one workaround, I'd created an expanded version in this thread:
Basically you create a calculated field with a value of 1 or 0 and have that as an axis, and then the label of that axis (whether it's a text axis or a bar chart) displays the value, and the color can be set as you wish by other calculated fields. It's hack that has some issues like text alignment being out of whack, they are documented in the workbook I'd posted.
The data will need to be reshaped so that the Brands are not each their own measure. If you are using Excel, this can easily be done using our Excel reshaper tool found here:
The following KB also shows how the data should be set up:
Hope this helps!
Hi Tracy. I knew reshaping would work, but in this case, reshaping the data would cause lots of re-work for the rest of the workbook, hence why I was hoping we could us the Measure Values field in a calc.
I use the re-shaper quite a bit and find it just lovely. I've been using it since it first came out. I haven't downloaded the new version yet.
Your solution is brilliant! It took me a minute to "get it" but it's exactly what I needed. Absolutely fantastic!
Thank you so much!
You're welcome! (And props to Joe Mako and the folks at Freaklytics for the original ideas).
It took a while to get 39 columns set up, but it's done and it looks fantastic. Thanks again!
This technique proved to make the viz a bit slow, so I decided to remove the "Zero" fields and keep only the "One" field for each measure. I didn't need the labels anyway, so essentially I removed half of the points that Tableau was trying to draw.
We're up to almost 50 different measures with their own colors, but the checkerboard affect when view it in the Entire View mode looks fantastic. It makes it so easy for people to spot issues.