5 Replies Latest reply on Jun 21, 2016 1:00 PM by Sharad Adhikari

# how to color code only one measure

Hi All,

How to color code only one measure out of n measures (in my case there are more than 7 measures)?

TIA

Warm Regards,

Srinivas

• ###### 1. Re: how to color code only one measure

Hi Srinivas,

Could you be more specific? Do you want to color code one measure in different color lets say green than other 6 measures lets say red?

BR

• ###### 2. Re: how to color code only one measure

Hi Sharad, Below is the data prototype. Group and Owner are Dimensions. The FY15, FY16, Diff, Change%, % of Total are the measures. I want the measures Diif and Change % to be color coded.

 Group Owner FY15 FY16 Diff Change% % of Total Group1 Owner1 10 11 1 10% 21% Group2 Onwer2 11 12 1 9% 23% Group3 Owner3 5 1 -4 -80% 2% Group4 Owner2 2 3 1 50% 6% Group5 Onwer3 3 5 2 67% 9% Group6 Owner4 5 9 4 80% 17% Group7 Owner3 10 2 -8 -80% 4% Group8 Onwer4 4 4 0 0% 8% Group9 Owner5 4 5 1 25% 9% Group10 Owner4 6 1 -5 -83% 2%

Warm Regards,

Srinivas

• ###### 3. Re: how to color code only one measure

Hi,

I assumed that you wanted to create a table calculation. Below is the attached tableau file (sheet 2).

I basic idea is to use fake measure and assign measures for each.

BR

1 of 1 people found this helpful
• ###### 4. Re: how to color code only one measure

I had not seen this fake measure method before, can you point me in the direction of any resources might explain it a bit more?

• ###### 5. Re: how to color code only one measure

Hi Benjamin,

I would get credit to this blog.

BR