hello ,
I have a scenario to color code the cell background based on the text value
of the cell.
for example
if sales rc = 'C' then 'Red'
if sales rc = 'X' then 'Yellow'
if sales rc = 'V' then 'Green'
The color coding is working easily for the numbers in the table but not to the
value
Any assistance would be greatly appreciated.
Thanks
-Sujatha
Sujatha,
You can drag both [Measure Names] and [your Color Logic] on the color shelf ( ctrl-click both and right-drag).
Next Edit the colors and set the R-Y-G for the Sales rc items , and white for all others.
Michel
Hi Michel,
Thanks for your response.
I am unable to drag both the measure names and the color logic calculated field on the color shelf.
I have 6 business functions as it shows in the image file, where I need to color the cell background based on the text value. I have tried looking at the related topics in forums but couldn't find the answer.
Can you post a packaged workbook.
If your data is sensitive, you can mockup something similar using the Superstore datasource provided with Tableau.
Hi Sujatha,
Refer
conditional formatting
http://drawingwithnumbers.artisart.org/older-but-still-useful-conditional-formatting/
Thanks
sankar