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,530 points

recategorized Mar 27, 2018 by Atul 2,256 views

1 answer to this question.

+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,240 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,530 points
281 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
1,928 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
• 31,840 points
856 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
• 31,840 points
146 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
50 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,240 points
1,375 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,240 points
52 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,240 points
3,703 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,240 points
178 views