5 Replies Latest reply on Oct 10, 2016 5:33 PM by Srinidhi Narayan

# Measure Values and Editing Color

How do I update the colors for my measure values in such a way that they display the same colors for the same range?

Range

100: blue

80-99 green

40-79 amber

39 and less red

• ###### 1. Re: Measure Values and Editing Color

You can create bins to represent the specific range(s) of values. Here is an article on that:  Creating Variable Sized Bins | Tableau Software

Use this newly created calculation instead of your existing measure in your viz, and you can then set the colors discretely for each bin.

• ###### 2. Re: Measure Values and Editing Color

This got me to the right direction. However, i still have some odd *****:

Any idea how i can fix these?

• ###### 3. Re: Measure Values and Editing Color

Can you please post the formulae you used to create the bins?  Or better yet, are you able to share the package workbook?

• ###### 4. Re: Measure Values and Editing Color

Srinidhi,

I modified the package slightly, please see attachment.

• ###### 5. Re: Measure Values and Editing Color

There are a couple of things going on here.

1.  When you use several measures in a crosstab, Tableau treats all the measures as a single entity (represented via the filtered measure values/measure names pills). when this happens, the options to manipulate the appearance of the measures in the viz independently are somewhat limited, or need a lot of creativity.

2.  The oddballs you are seeing arent odd at all.  The RAG calculation is combining both measures in the same calculation, and giving one combined evaluated discrete result per row of data.  You will notice that both the cells in that row have the same color.

Here are a couple of alternative ways to represent the information.    In the attached I separated the calculation to treat each measure independent of the other.  And then I am applying the colors by using a viz type that allows me to treat each of the measure independently, using separate marks cards.

I just realized your original was from version 9.2.   The attached is version 10.  I hope you have the ability to open a version 10 file.  If not, you could download and install version 10 alongside the older version.  However, be cautioned that the windows default will switch over to the version that was most recently installed.

If that is not feasible, let me know, and I will try to recreate in 9.2.