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:
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:
The following tutorials explain how to perform other common tasks in Power BI: