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 ffdfd
• 5,550 points

recategorized Mar 28, 2018 by ffdfd 9,832 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 28, 2018 by ffdfd
@Grim ThankYou for answering this query. It completely worked fine as per my requirement.

Related Questions In Tableau

0 votes
1 answer

Dynamically set the value of a filter based on a parameter selection in use to swap sheets

Here's a simplified example of the calculated ...READ MORE

answered Apr 29 in Tableau by anonymous
• 1,380 points
2,093 views
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 9, 2018 in Tableau by ffdfd
• 5,550 points
4,765 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
15,296 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, 2019 in Tableau by Cherukuri
• 33,030 points
17,109 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 14, 2018 in Tableau by xyz
• 1,560 points
766 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 25, 2018 in Tableau by Atul
• 10,240 points
7,612 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 29, 2018 in Tableau by Atul
• 10,240 points
981 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
11,664 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 24, 2018 in Tableau by Atul
• 10,240 points
2,563 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP