Power BI: How to Create a Line Chart by Month


Often you may want to create a line chart that displays the values of some variable summarized by month.

The following step-by-step example shows how to create the following line chart by month in Power BI:

Power BI line chart by month

Let’s jump in!

Step 1: Load the Dataset

First, we will load the following dataset into Power BI that contains information about the total sales made on various dates by some company:

Step 2: Insert the Line Chart

Next, click the Report View icon on the left hand side of the screen:

Then, on the right side of the screen under Visualizations, click the Line chart icon:

An empty line chart will be inserted:

Step 3: Populate the Chart

Next, drag the Date variable under the X-axis label, then drag the Sales variable under the Y-axis label:

Next, delete the Year, Quarter and Day options under the Date dropdown menu so that only Month remains:

The end result will be a line chart that displays the sum of sales by month:

Power BI line chart by month

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Create a Stacked Column Chart in Power BI
How to Plot Multiple Lines on Line Chart in Power BI
How to Add Trend Line to Line Chart in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *