What is Path in Tableau?
If you've ever created a scatter plot in Tableau, you've seen a collection of dots representing your data points. But what if you need to show how those points connect over time or follow a specific sequence? That’s where Tableau’s Path property comes in, turning your static dots into a dynamic story. This article will show you exactly what the Path property does and how to use it to visualize trends, journeys, and progressions in your data.
What is the Path Property in Tableau?
The Path property on the Marks card in Tableau tells your visualization how to connect the dots. Think of it as a set of instructions for a connect-the-dots puzzle. Without it, you just have a scatter plot of individual data points. When you add a dimension to the Path shelf, you're telling Tableau the specific order in which to draw a line from one point to the next.
This simple action has a huge impact on your visualization's storytelling ability. It transforms a simple chart from showing just relationships between variables to showing a progression or a journey. It’s the key to creating things like:
- Time-Series Plots: Tracking the movement of a metric over minutes, days, or years.
- Connected Scatter Plots: Showing how the relationship between two measures has evolved over time.
- Geographic Maps: Visualizing the path of a delivery truck, a storm, or a flight route.
Essentially, any time you want to add a sense of sequence or flow to your visualization, the Path property is the tool you need.
When Should You Use the Path Property?
The Path property is perfect for any scenario where the order of your data points matters as much as their individual values. It reveals the narrative hidden within your data sequence.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Visualizing Trends as Connected Scatter Plots
This is one of the most powerful and common use cases. Imagine you have data for your website's monthly traffic and conversion rate. A regular scatter plot would show you if there's a correlation - maybe higher traffic generally means a lower conversion rate - but it's just a cloud of dots. You can't see the chronological story.
By using the Path property with your date or month field, you can connect the dots in order from January to December. Suddenly, you can see the narrative: “In Q1 traffic was low but conversion rate was high. In Q2, we ramped up ad spend, which increased traffic but hurt the conversion rate. Then a website redesign in Q3 brought the conversion rate back up even as traffic continued to grow.” The path tells the story of your year.
Mapping Geographic Journeys
If your data includes latitude and longitude coordinates along with a sequence identifier (like a timestamp or a trip ID), the Path property is essential for drawing routes on a map.
- An airline can map flight paths between airports.
- A logistics company can visualize the precise route a delivery truck took.
- A meteorologist can track a hurricane's forecasted path.
In each case, you'd place longitude on the Columns shelf, latitude on the Rows shelf, and the chronological field (like a date/time stamp) onto the Path property to draw the line connecting the geographic points in the correct order.
Showing a Flow or Process
You can also use Path to illustrate a process that isn't dependent on time or geography. For instance, if you're analyzing scientific experiment data, you might want to show how a substance changes character as temperature and pressure are adjusted sequentially. Placing the 'Step Number' or 'Stage ID' on the Path property will connect the dots according to the experimental procedure.
How to Use Path in Tableau: A Step-by-Step Guide
Let's walk through a practical example using a typical marketing dataset. We want to create a connected scatter plot to see how our Paid Search channel’s Spend and Cost per Conversion have changed each month over the last year.
Step 1: Get Your Data Ready
Before you jump into Tableau, make sure your data is structured properly. For a connected scatter plot, you'll need at least three key fields:
- A measure for your X-axis (e.g., Monthly Ad Spend)
- A measure for your Y-axis (e.g., Cost per Conversion)
- A date or ordered dimension for the path (e.g., Month)
If you wanted to compare multiple lines on the same chart (like different marketing channels), you would also need a dimension to separate them (e.g., Channel).
Step 2: Create the Basic Scatter Plot
First, we build the foundation of our chart - the scatter plot. This will create the individual "dots" we'll eventually connect.
- Open a new sheet in Tableau and connect to your data source.
- Drag your X-axis measure, Ad Spend, onto the Columns shelf.
- Drag your Y-axis measure, Cost per Conversion, onto the Rows shelf.
Right now, you’ll probably just see a single dot. This is because Tableau has aggregated all of your data. To break it down into monthly points, we need to add a level of detail.
- Drag your date dimension, Month, onto the Detail part of the Marks card.
You should now see multiple marks, one for each month in your dataset. It’s officially a scatter plot, but the story is still missing.
Step 3: Connect the Dots with Path
Now for the main event. Let's tell Tableau the order in which to connect these monthly data points.
- On the Marks card, click the dropdown menu that says “Automatic” and change the mark type to Line. The points might vanish or turn into a strange scribble for a moment - that’s okay.
- Drag the same date dimension, Month, from the Data pane onto the Path property on the Marks card.
Instantly, a line appears, connecting your data points chronologically. You can now see the journey your marketing performance took throughout the year. The shape of the path tells a story about the relationship between your spend and your efficiency.
Step 4: Refine and Add More Context
The basic line is there, but we can make it more insightful.
- Add Markers for Each Point: Sometimes the line alone can be hard to read. You can add the dots back by clicking on the Color shelf in the Marks card and selecting "Markers" under the "Effects" section. This gives you a clear point for each month along the line.
- Label Your Start and End Points: To make the chronological flow ultra-clear, create a calculated field to identify the first and last months. You can then drag this new field onto the Label shelf to highlight the beginning and end of your year.
- Use Color and Size Creatively: Want to add another layer of information? Drag another measure, like Total Conversions, onto the Size shelf. Now, the points along your path will get bigger for months with more conversions. Or, if you are plotting multiple channels, drag the Channel dimension to the Color shelf to create a separate colored path for each one.
Common Mistakes and Troubleshooting
Using the Path property is straightforward, but a few common missteps can trip you up. Here’s what to watch out for.
Mistake #1: Forgetting to Change the Mark Type to "Line"
This is the most frequent issue. If you drag a field to the Path shelf but leave the mark type as Automatic or Circle, nothing will happen. You'll still see just your scatter plot dots. The Path property only works with the Line or Polygon mark types. Always remember to switch the mark type to Line first.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Mistake #2: Using the Wrong Field for the Path
The field you place on Path must represent a logical sequence. It needs to be a date, a timestamp, or a number that indicates order (like Step 1, Step 2, Step 3). If you accidentally drag a categorical dimension like "Product Category" onto the Path shelf, Tableau will try to connect the dots in alphabetical order, resulting in a meaningless spiderweb of lines crossing all over the chart.
Mistake #3: Your Line Folds Back on Itself
If you see a line suddenly go backward, your Path field isn't detailed enough. This can happen if you use a field like "Month Name" (e.g., January, February) when your data spans multiple years. Tableau might connect all the "Januarys" together because it can't distinguish between January 2023 and January 2024. The fix is to use a more specific date field that includes the year (like MONTH(OrderDate)) to ensure the sequence is unique and continuous.
Final Thoughts
The Path property is a deceptively simple feature in Tableau that unlocks a profound level of storytelling. By telling Tableau the order in which to connect an otherwise static collection of data points, you can clearly visualize trends, map out journeys, and reveal the narratives hidden in your data's sequence.
Learning tools like Tableau is rewarding, but it can also feel like an uphill battle against complex features and a steep learning curve. We understand that marketers and business owners often need immediate insights without spending hours learning a new tool from scratch. That's why we built Graphed, where you can skip the manual setup. Instead of dragging fields to shelves, you simply ask in plain English, "Show me a chart tracking ad spend versus cost per conversion for the last 12 months," and our AI instantly builds the interactive visualization for you, delivering the insight you need in seconds, not hours.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.