The description you've written is too vague for me to understand the problem--please post a packaged workbook (.twbx file) or at least screenshots as well as a mock up of what you are wanting, so that you can get the best possible help available.
See: http://community.tableau.com/docs/DOC-5065 for more info on how to get the best help possible from the forum.
We really do want to help. Cheers.
What is the logic behind greying it out? is it based on some criteria?
Since the value of Metric 3 is a %
1 of 1 people found this helpful
If that is how your data is actually structured why not just add Measure Names to the color shelf and do it manually?
What is a more ideal situation is if you had a Measure for Metric. Create a calculated field for the values so ex:
IF [Metric] < 51% THEN "Good"
Then throw that on the color shelf and make anything "Bad" grey.
Here is the Measure Names solution Kyle mentioned.
The measure he wants to grey out is a table calc % of difference calculation. I tried defining it explicitly (because he had use the built in quick table calcs), and was unable to use an IF statement to grey out the color. Each metric has its own measure, so therefore each % Difference calc has its own measure, so I believe that has an impact.
Sample data workbook ML.twbx.zip 21.2 KB
Thanks, Kyle and Matt!