Online tableau training, tableau tips, & video tutorials

Tips

Memberships

How to Color Entire Tableau Charts Based on Current Performance

Preview

Instructor

Ryan Sleeper

Encode Entire Trend Charts with a Single Comparison

Have you seen stock ticker gauges that show a full trend line that is colored by only the most recent performance? In this video, Ryan shows you how to do something similar with a single calculated field to add a nice (and effective!) aesthetic to your visualizations.

This video is currently being professionally transcribed. The full written transcript will be available soon.

Related video: An Introduction to Tableau Table Calculations
Related video: How to Automatically Highlight Highs and Lows in Tableau
Related video: How to Make Sparklines in Tableau
Related video: 3 Ways to Make Lovely Line Graphs in Tableau
Related blog post: How to Color Entire Tableau Charts Based on Latest Performance

Calculated field that compares the current month’s Sales value to the previous month’s Sales value:

WINDOW_MAX(IF LAST() = 0 THEN SUM([Sales]) END)
>
WINDOW_MAX(IF LAST() = 1 THEN SUM([Sales]) END)

Tips Videos
  1. How to Dynamically Format Numbers in Tableau
  2. How to Conditionally Format Individual Rows and Columns in Tableau Like You Can in Excel
  3. How to Allow Users to Choose Dimensions and Measures in Tableau
  4. Exercise: Sales by Category, Region, Segment, or Ship Mode
  5. How to Color Entire Tableau Charts Based on Current Performance
  6. How to Color and Size Entire Tableau Table Rows
  7. Using Tableau’s INDEX() Function for Easier Top N Filtering
  8. How to Make Tableau Histograms with Aggregate Calculated Fields
  9. How to Make Dynamic Tooltips in Tableau
  10. How to Add an Image to a Tableau Tooltip
  11. How to do Automatic Anomaly Detection in Tableau
  12. How to Make Rounded Gauges in Tableau
  13. How to Add a Tooltip to a Dimension in Tableau
  14. Two Ways to Make a Tableau Timeline when Events Overlap
  15. 3 Creative Ways to Use Transparent Sheets in Tableau
  16. How to Automatically Change Number Units in Tableau
  17. How to Drill into a Single Row in Tableau
  18. A Formatting Trick for Tableau Scatter Plots and Maps
  19. How to do Sheet Swapping with Tableau Layout Containers
  20. How to Use Measure Names in Tableau Calculated Fields
  21. How to Use Control Sheets for Better Parameter Actions
  22. How to Deduplicate Joined Rows in Tableau
  23. How to Add Vertical Connecting Lines to Tableau Slope Graphs
  24. How to Align Text Like Finance Reports in Tableau
  25. How to Show Top N Lists in Tableau Tooltips
  26. How to Flexibly Format Decimal Places in Tableau