If you've spent any time in Tableau, you've probably noticed those little blue and green pills dotted around your workbook. At first glance, they don't seem particularly important, they're just colours, right?
Not quite.
That tiny colour difference is one of the biggest reasons why your visual might tell the perfect story... or completely miss the mark.
When I first started using Tableau, I'd drag a date field onto a chart and wonder why sometimes I got a tidy set of monthly headers, while other times I ended up with a continuous timeline. Same data. Same chart. Completely different result.
The answer was hiding in plain sight: blue vs green.
The blue pill: Compare
A blue pill tells Tableau to treat your data as discrete. In simple terms, it splits your data into separate buckets.
Think months, regions, product categories or customer segments.
Instead of showing a timeline, Tableau creates headers, making it easy to compare one group against another.
Want to know which month had the highest sales? Or which region outperformed the rest? Blue is your friend.
The green pill: Follow the story
Green pills work differently.
Instead of creating categories, Tableau creates an axis. Your data becomes part of one continuous journey.
This is where trend analysis comes alive.
Rather than asking "Which month performed best?", you're asking "How has performance changed over time?"
It's the difference between looking at snapshots and watching the whole movie.
Why it matters
This isn't just about making charts look different.
It's about asking the right question.
The best dashboards don't just display data, they guide people towards an answer. Choosing between a blue or green pill changes the question your visual is helping someone answer.
The same dataset can tell two completely different stories depending on which one you choose.
So... which pill should you take?
Thankfully, there's no Matrix-style consequence here.
If you want to compare categories, choose blue.
If you want to show change over time, choose green.
It's one of those small Tableau concepts that can have a surprisingly big impact. Once it clicks, you'll spend less time wondering why your chart looks "wrong" and more time building visualisations that communicate exactly what you intended.
Sometimes, the smallest decisions make the biggest difference.