Best option is to use the same technique used here. If that doesn't make sense, look around for other articles using MIN(1) to accomplish the same thing - there are a number out there.
- Put MIN(1) onto Rows
- Put your actual measure onto text
- Convert to a bar chart
- Fix axis from 0 to 1
- Click size and move the slider all the way to the right
- Drag the relevant field onto color
1 of 1 people found this helpful
I helped pioneer the technique that Ben & Allen linked to (see Older But Still Useful – Conditional Formatting | Drawing with Numbers ) and I avoid it as much as possible because it adds complexity to building the view, makes maintaining the view more difficult, impacts performance, and has some unavoidable display issues such as extra white space.
If all you want is to color the metrics by positive/negative there's an easier way than the suggestions here, just put Measure Values on color and edit the color range to have 2 steps:
We can also get a highlight table using this technique:
And finally if you want a different color ramp for each measure and you're on Tableau v10.2 or higher you can right-click on the Measure Values and choose "Use separate legends" to turn on the Legends per Measure feature, here I'm using it in a highlight table:
v10.2 workbook is attached, hope this helps!