How to color code cells of a column based on the text value in Tableau

0 votes

I'm a new tableau developer trying to develop a table based tableau report. I have a column in the table called "Status" which essentially contains 3 values "In progress", "Blocked" and "Completed". I want to colour code the cells of this column based on these text values. Did anyone face this problem? Kindly let me know how you solved it.

Mar 27, 2018 in Tableau by Atul
• 5,510 points

recategorized Mar 27, 2018 by Atul 1,152 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
+1 vote
Best answer

You can use the following steps to get it resolved

  1. Drag the Status to Color on the Marks card.

  2. Optimize the view format:

    • On the Marks card, select Square as the mark type.

    • Make the columns wider by pressing Ctrl + Right arrow (on a Mac, the combination is z"). Hold down Ctrl (or z) and continue pressing the Right arrow key until the headings for Segment are displayed in full:

    • Increase the mark size by pressing Ctrl + Shift + B (on a Mac: ñzB). Hold down Ctrl + Shift (ñz) and continue to press B until the squares are large enough.

  3. Drag Status to the Text on the Marks card

Using this you will get the desired visualization
answered Mar 27, 2018 by Atul
• 10,220 points

selected Mar 27, 2018 by Atul
@Grim ThankYou for answering this query. It completely worked fine as per my requirement.

Related Questions In Tableau

0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,510 points
77 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
804 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12 in Tableau by CHERUKURI
• 15,740 points
135 views
0 votes
1 answer

How to fetch the previous value in a column or row?

Hi Sindhu, You can use LOOKUP() or PREVIOUS_VALUE() in ...READ MORE

answered May 22 in Tableau by CHERUKURI
• 15,740 points
13 views
0 votes
1 answer
0 votes
1 answer

How interactive graphs are generated in Tableau?

Lot of back end code is shared ...READ MORE

answered Apr 13, 2018 in Tableau by xyz
• 1,550 points
27 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 24, 2018 in Tableau by Atul
• 10,220 points
471 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,220 points
30 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,220 points
1,767 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 23, 2018 in Tableau by Atul
• 10,220 points
79 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.