When working with data, one of the most common questions is: “How is my data changing over time?”
This is where a line chart in Tableau becomes very powerful. A line chart helps you understand:
- Trends
- Growth or decline
- Patterns over time
For example, businesses use line charts to track:
- Sales growth month by month
- Website traffic trends
- Profit changes over years
Line charts are one of the most widely used visualizations because they are simple, clear, and powerful for decision-making.
While working for a retail furniture supplier, we were analyzing quarterly sales trends for the current and previous years.
To visualize this data, I created a Line chart that shows Sales over the year, broken down by quarter. Using the line chart, we identified sales patterns, including drops and spikes in sales figures.
In this blog, I will explain about the Line chart in Tableau and how you can use it to visualize and analyze your data.
What is a Line Chart in Tableau?
A line chart in Tableau is a visualization that shows how a value changes over time.
It connects multiple data points using a line, where:
- X-axis = Time (date, month, year)
- Y-axis = Measure (sales, profit, count)
Each point on the line represents a value at a specific time, and the line shows whether values are:
- Increasing
- Decreasing
- Stable
In Tableau, a Line chart shows how data changes over time by comparing date values. It displays the data points for the values connected through a straight line.
Each point on the line represents a value at a specific time, and when connected, the line indicates whether the values are increasing, decreasing, or remaining constant.
In Tableau, there are two main types of line charts: continuous and discrete. Both of these line chart types can be accessed from the Show Me menu when creating a line chart.
Continuous Line Chart:
In a Tableau continuous line chart, the line connects the data points on the continuous axis. The values on the axis are in sequence without breaks, such as days, months, or years.
For example, to track the quarterly sales of two years, a continuous line chart in Tableau will show the rise or fall of sales quarter by quarter by connecting the data points.
Discrete Line Chart:
A discrete line chart in Tableau uses separate values on the axis, like specific months, categories, or regions, rather than a continuous line across a range of values. These values are considered labels rather than a continuous flow.
To create a discrete chart, use a date or dimension field on the Columns or Rows shelf, which results in individual lines for each category.
Check out: Tableau Dual Axis Chart
Differentiate the Continuous and Discrete fields:
On the Dimension sidebar, we see a number of fields; the ones in green are continuous fields, and the ones in blue are discrete fields.
Create a Line Chart in Tableau
In the examples below, we will create a line chart for both the Continuous line chart and the Discrete line chart.
Create a Discrete Line Chart in Tableau
In this example, we will create a line chart using the date dimension. In the line charts, the date dimension is the only exception that can be both continuous and discrete.
The line chart below displays the product sales for each quarter over the years.
- In the Rows shelf, add the Sales dimension. After this, add the Order Date to the Columns field.
After adding the order date column, it will be displayed in the year format by default.

Now, the chart will automatically display in the line format after adding the Date and Sum fields.
- To make the chart discrete, we will add another Order Date again to the Columns and change the format to Quarter.

Now, the line chart will be divided into sales for each quarter of a specific year.

As we can see after breaking down the data into quarters, separate sections are created for each year, displaying their quarterly sales in a single continuous part. Here, the first line chart is not connected to the other one; hence, it is a discrete chart.
Check out: Bullet Chart in Tableau
- To display sales values for each quarter in specific years, add Sales to the Label card in the Marks section.

This is how you can create a discrete line chart in Tableau, where each section displays a line chart with no relationship to the others.
There are a few instances when you can confuse a discrete line chart with a continuous one. Although we can differentiate between green and blue fields, some discrete charts appear continuous.
For example, if we remove the Year(Order date) from the above chart, the Rows will have a discrete part of all the quarters. Here, Quarter 1 (Q1) displays the sales for Q1 across all years.

To determine the years, we again need to add the Year (Order date). This will display the discrete line charts. To see the connection between all the years for each quarter, we need to create a continuous line chart.
Check out: Tableau Gauge Chart
Create a Continuous Line Chart in Tableau
To create the Continuous Line Chart, we take the same example as the previous one, where we will display the yearly Sales trends for all quarters for each year.
Unlike the discrete chart, the continuous chart will display the relationship between all the years.
- Add the Order Date to the Rows and Sales field to the Columns.

- Now, you will see the Order Date in blue color, which means it is discrete. To make the date field continuous, click on it and select Year.
Here, you will see duplicate date values; the top ones are discrete, and the bottom ones are continuous.

- As we select the Year from the continuous date field, the Year(Order Date) will appear in green, indicating that it is now a continuous field.
To add other measures, like Quarter, click on the ‘+’ icon on the date field.

- Now, you will see that the added fields Quarter and Years will appear in the same field. It won’t create a separate field in the Columns and won’t display a different chart.
As we hover over the data point in the line chart, it will display the quarter and year corresponding to that data point.

- At last, to display the sales figures, add the Sales field to the Label card in the Marks section.

By following these steps, we can convert a discrete date field to a continuous one and create a continuous Line Chart in Tableau.
I hope the examples we discussed above help you understand how to use line charts in Tableau, differentiate between continuous and discrete line charts, and select the appropriate one for your data visualization.
Continuous vs Discrete Line Chart (Comparison)
| Feature | Continuous Line Chart | Discrete Line Chart |
|---|---|---|
| Data Type | Continuous | Categorical |
| Line Flow | Smooth | Broken/Separate |
| Axis | Continuous scale | Labels |
| Use Case | Trend analysis | Category comparison |
| Example | Sales over time | Sales per quarter |
Frequently Asked Questions
1. What is a line chart in Tableau?
A line chart shows changes in data over time by connecting data points with a line. It helps identify trends, patterns, and growth.
2. What is the difference between continuous and discrete line charts?
Continuous charts show smooth trends over time, while discrete charts display separate categories without a continuous flow.
3. When should I use a line chart?
Use a line chart when:
1. You want to show trends over time
2. You have time-based data
3. You want to compare performance
4. Can I show multiple lines in Tableau?
Yes, you can add multiple lines by using:
1. Category or dimension in Color
5. Why is my line chart not showing correctly?
Possible reasons:
1. Wrong data type (discrete vs continuous)
2. Missing values
3. Incorrect field placement
Conclusion
A Tableau line chart is one of the most powerful tools for analyzing time-series data.
It helps you:
- Understand trends
- Make better decisions
- Visualize data clearly
By learning:
- Continuous vs discrete charts
- Proper setup
- Best practices
You can create professional dashboards that deliver real business insights.
You may also like to read:
- Tableau Funnel Chart
- Gantt Chart in Tableau
- Build a Bar in Bar Chart in Tableau
- Pareto Chart in Tableau
- Lollipop Chart in Tableau
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.