Step-by-Step Guide to Create a Line Vs Column Chart in Power BI

1. Open Power BI Desktop:

Launch Power BI Desktop on your computer.

2. Load Your Data:

Click on Home > Get Data.

Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.

3. Select the Data for the Line And Clustered Column Chart:

In the "Fields Pane", select the data fields you want to visualize. For example, you might choose Date and sales.

4. Insert a Line And Clustered Column Chart:

Go to the "Build" pane on the right side.

Click on the Line And Clustered Column Chart icon.

5. Configure the Line And Clustered Column Chart:

Drag the desired fields to the appropriate areas in the Build pane

6. Customize the Line And Clustered Column Chart:

Use the "Format" pane to customize the appearance of your chart. You can change colors, add data labels, adjust axis titles, and more.

7. Save Your Report:

Once you're satisfied with your chart, save your report by clicking on File > Save As.

Example

Load the Sales Data:

Import your sales data into Power BI.

Create the Line And Clustered Column Chart:

Select the "Line And Clustered Column Chart" from the "Build" pane.

Add Fields:

Drag the "Order date" field to the "X - axis" 

Drag the "Sales " field to the "Column Y - axis" 

Drag the "Profit " field to the "Line Y - axis" 

Customize:

Use the "Format" pane to adjust the chart's appearance.

By following these steps, you should be able to create a Line chart in Power BI that effectively visualizes your data

Try Following Formatting Options

1. See which region had highest sale in the year 2019

Drag the "Region" field to the "Legend" - You will be able to see the sales according to Region 

2. Compare sales between the years

Just change the existing chart type to "Line And Stacked Column Chart" - You will be able to see the sales according to years and compare them 

3. See which category had highest sale in the year 2017

Drag the "Category" field to the "Legend" - You will be able to see the sales according to Category