Tableau Essentials: Formatting Tips – Color

Data

Tableau Essentials: Formatting Tips – Color

Not everyone is a Tableau guru, at least not yet. To help Tableau rookies, we’re starting from square one with the Tableau Essentials blog series. The series is intended to be an easy-to-read reference on the basics of using Tableau Software, particularly Tableau Desktop. Since there are so many cool features to cover in Tableau, the series will include several different posts.

In this edition of Tableau Essentials, we’ll examine the Color button on the Marks card. Color options are a powerful way to add distinction to your visualization as well as depth to your data’s story.

Marks Card

The most important thing to keep in mind is that you can color your marks by a discrete field OR a continuous field. We’ll examine the difference in this blog and explore options for adding color to your viz.

Color by Discrete Field

As discussed in previous posts in this series, discrete fields have a unique list of items. In the view below, I made a simple bar chart showing the SUM(Shipping Costs) by each SubRegion in our sample data source. The bars are sorted in descending order, and I dropped SubRegion on the Color shelf.

Simple bar chart 

Notice that there are just four items in the SubRegion field: Central, East, West and South. When we click on the Color shelf, we have the option to edit the colors for these items:

Edit Colors 

You can select from a list of color palettes that come standard with the Tableau Desktop software. You can also create and add your own custom color palette.

Color by Continuous Field

Using the same bar chart, I’ve swapped out the SubRegion field on the Color shelf with the measure Shipping Cost. See the results below:

Swapping measures and fields 

Notice that the color legend shows a continuous color range from light to dark green. Continuous fields have a range of values. By default, Tableau is coloring the bars based on the SUM(Shipping Cost), noting $23,379 is the smallest value and $37,515 is the largest. We can see where Tableau is getting this scale from by adding the mark labels (clicking the Abc icon on the toolbar):

Add mark labels

Just as we can edit the color palette for a discrete field, we can edit the color palette for a continuous field.

Edit colors 

We have several options for controlling the colors of our bars. Not only can we select a completely different color palette (let’s choose a palette that’s color blind friendly as a best practice), we can also choose whether it’s a gradient from orange to blue:

Edit colors 

We can then choose to set the range into a set number of sections using the Stepped Color option. Reversed will just flip our colors to go from blue to orange. We can use the Advanced options to further refine the range:

Edit colors 

Here’s the result of our changes to the continuous color palette:

Continuous color palette 

Here’s something to consider: What if you wanted to create a view where if the SUM(Shipping Cost) is greater than $25,000, the bar would be blue (otherwise it would be grey)? There are a couple of ways we can do this, but one way is to create a simple calculated field and use that field to control the color of your bars. Below is the formula we’ll use for this scenario:

Shipping Cost > 25k” height=”91″ src=”/wp-content/uploads/sites/default/files/blog-content/TEFTColor10.png” width=”282″ /> </p>
<p>The outcome of this formula is either <strong>True</strong> or <strong>False</strong>, therefore we have created a discrete measure (more on this topic in a future blog). When we put this field on the <strong>Color</strong> shelf, we get the following viz:</p>
<p><img decoding=

It’s a simple formula, but as you continue to collect data and refresh your data source, maybe the blue bar will reach $25,000 and turn grey one day!

Adjusting the colors of your marks and your visualization is ultimately more of an art than a science, but Tableau makes it easy to experiment. Just remember to use that Undo option every time you make a change that doesn’t suit your eye.

Pro Tip: If you really want to take your color palettes to the next level, check out our Color Tool for Tableau.

Formatting Tips

Below is a complete list of Formatting Tips posts that can help you transform your vizzes into works of arts. Check back frequently for new additions.

Introduction

  1. Custom Shapes
  2. Labels
  3. Color
  4. Tooltips
  5. Maps

More Tableau Essentials

Want to learn more about Tableau? We have several posts outlining all of Tableau’s fantastic features. Check out the full list on our Tableau Essentials blog channel.

As always, let us know if you have any questions or comments about this post or Tableau in general. If you’re looking for personalized training or help with something bigger, contact us directly!

Want More Tableau Essentials

  1. Tableau Essentials: Chart Types – Introduction
  2. Tableau Essentials: Chart Types – The Text Table
  3. Tableau Essentials: Chart Types – Heat Map
  4. Tableau Essentials: Chart Types – Highlight Table
  5. Tableau Essentials: Chart Types – Symbol Map
  6. Tableau Essentials: Chart Types – Filled Map
  7. Tableau Essentials: Chart Types – Pie Chart
  8. Tableau Essentials: Chart Types – Horizontal Bar Chart
  9. Tableau Essentials: Chart Types – Stacked Bar Chart
  10. Tableau Essentials: Chart Types – Side-by-Side Bar Chart
  11. Tableau Essentials: Chart Types – Treemap
  12. Tableau Essentials: Chart Types – Circle View
  13. Tableau Essentials: Chart Types – Side-by-Side Circle View
  14. Tableau Essentials: Chart Types – Line Charts (Continuous & Discrete)
  15. Tableau Essentials: Chart Types – Dual-Line Chart (Non-Synchronized)
  16. Tableau Essentials: Chart Types – Area Charts (Continuous & Discrete)
  17. Tableau Essentials: Chart Types – Scatter Plot
  18. Tableau Essentials: Chart Types – Histogram
  19. Tableau Essentials: Chart Types – Box-and-Whisker Plot
  20. Tableau Essentials: Chart Types – Gantt Chart
  21. Tableau Essentials: Chart Types – Bullet Graph
  22. Tableau Essentials: Chart Types – Packed Bubbles
  23. Tableau Essentials: Formatting Tips – Introduction
  24. Tableau Essentials: Formatting Tips – Custom Shapes
  25. Tableau Essentials: Formatting Tips – Labels
  26. Tableau Essentials: Formatting Tips – Color
  27. Tableau Essentials: Formatting Tips – Tooltips
  28. Tableau Essentials: Formatting Tips – Maps
  29. Tableau Essentials: Calculated Fields – Introduction
  30. Tableau Essentials: Calculated Fields – Logical Functions
  31. Tableau Essentials: Calculated Fields – Number Functions
  32. Tableau Essentials: Calculated Fields – Date Functions
  33. Tableau Essentials: Calculated Fields – String Functions
  34. Tableau Essentials: Calculated Fields – Type Conversion
  35. Tableau Essentials: Calculated Fields – Aggregate Functions
  36. Tableau Essentials: Calculated Fields – User Functions

More About the Author

Robert Curtis

Managing Director, APAC
Kickstarting Data Innovation in Healthcare On 13 March 2024, InterWorks was a proud Platinum sponsor of the first ever Data & Analytics in Healthcare conference, hosted by ...
Building Solutions with InterWorks at Corinium’s Data Architecture Conference in Melbourne InterWorks was a proud sponsor of the Data Architecture Conference hosted by Corinium in Melbourne on 21 and 22 June 2023. Hundreds of ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!