4 Replies Latest reply on Feb 6, 2018 9:32 AM by John Trevino

Changing colors in one sheet, changes colors in other sheets

Georgi Shopov Jan 25, 2017 12:47 AM

Hello,

I have a annoying issue in Tableau. I guess it is something I am missing so I hope someone can help.

I have 4 sheets in which I compare Birth & Fertility rate in Cities & Villages.

Birth & Fertility rate for Cities (sheet 1)
Birth & Fertility rate for Villages (sheet 2)
Birth rate for Cities & Villages (sheet 3)
Fertility rate for Cities & Villages (sheet 4)

And here come the problem ... changing color for Birth & Fertility rates in one of the sheets affect the colors in the other sheets... why?

To me this is a problem because in sheet 1 & 2 the colors are Green & Red. And for sheets 3 & 4 where I compare same value for different places, I want to use different nuances..

Can someone please assist me?

1. Re: Changing colors in one sheet, changes colors in other sheets

Wim Kegels Jan 25, 2017 2:01 AM (in response to Georgi Shopov)

Hi Georgi,

This is due to Tableau assigning te colors to the field, not the sheet. One simple workaround is to duplicate your field (right click - duplicate) and use one field for sheet 1&2, and the other field for sheets 3&4.

Hope this helps!

Kind regards,
Wim
1 of 1 people found this helpful
Like Show 2 Likes(2)

Actions
2. Re: Changing colors in one sheet, changes colors in other sheets

Georgi Shopov Jan 25, 2017 3:54 AM (in response to Wim Kegels)

Well, that is a work around. I will try it right away. But this thing that you said.. about assigning the color to the worksheet or the field. How do you do that? Because this will be better workaround I believe.
Like Show 0 Likes(0)

Actions
3. Re: Changing colors in one sheet, changes colors in other sheets

Wim Kegels Jan 25, 2017 3:56 AM (in response to Georgi Shopov)

Hi Georgi,

there currently is no way to set field colors for specific worksheets. The workaround is (afaik) the only way.

Kind regards,
Wim
1 of 1 people found this helpful
Like Show 2 Likes(2)

Actions
4. Re: Changing colors in one sheet, changes colors in other sheets

John Trevino Feb 6, 2018 9:32 AM (in response to Wim Kegels)

Too bad such a powerful tool has this "issue". That would be too cumbersome a workaround. I'll choose to live with it for now.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Changing colors in one sheet, changes colors in other sheets

1. Re: Changing colors in one sheet, changes colors in other sheets

2. Re: Changing colors in one sheet, changes colors in other sheets

3. Re: Changing colors in one sheet, changes colors in other sheets

4. Re: Changing colors in one sheet, changes colors in other sheets

Actions

More Like This