7 Replies Latest reply on Oct 15, 2013 12:47 PM by priya.goel

# Graying out cells in Tableau

I have several measures and need to gray out MOM% for certain metrics (since they are percentages). Please can you suggest the best way of doing that?

• ###### 1. Re: Graying out cells in Tableau

Hello Priya:

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.

• ###### 2. Re: Re: Graying out cells in Tableau

Please see attached for the packaged workbook along with the screenshot.

• ###### 3. Re: Re: Graying out cells in Tableau

What is the logic behind greying it out?  is it based on some criteria?

• ###### 4. Re: Re: Graying out cells in Tableau

Since the value of Metric 3 is a %

• ###### 5. Re: Graying out cells in Tableau

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"

ELSEIF "Bad"

END

Then throw that on the color shelf and make anything "Bad" grey.

Cheers!

1 of 1 people found this helpful
• ###### 6. Re: Re: Re: Graying out cells in Tableau

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.

1 of 1 people found this helpful
• ###### 7. Re: Graying out cells in Tableau

Thanks, Kyle and Matt!