Line and Clustered Column Chart in Power BI

Power BI Line and Clustered Column Chart is useful to visualize multiple dimensions and measures. Let me show you how to Create a Line and Clustered Column Chart in Power BI with example.

For this Power BI Line and Clustered Column Chart demonstration, we are going to use the Excel Data Source that we created in our previous article.

Please refer to Connect Power BI to Excel Multiple Excel Sheets article to understand the Power BI Data Source.

How to Create a Line and Clustered Column Chart in Power BI

To create a Line and Clustered Column Chart, first Drag and Drop the Sales from Fields section to Canvas region. It automatically creates a Column Chart, as we have shown below.

Line and Clustered Column Chart in Power BI 1

Click on the Line and Clustered Column Chart under theVisualizationsection. It automatically converts a Column Chart into a Line and Clustered Column Chart. Currently, you don’t see the change, because you have to add a few more fields.

Line and Clustered Column Chart in Power BI 2

Let me add Region to Shared Axis section, and Profit to Line Values section to convert it into the Line and Clustered Column Chart.

Line and Clustered Column Chart in Power BI 3

Next, we are adding Customer Segment to the Column Series section to convert it into the Clustered Column Chart.

Line and Clustered Column Chart in Power BI 4

Create a Line and Clustered Column Chart in Power BI Approach 2

First, click on the Line and Clustered Column Chart under the Visualization section. It will create a Line and Clustered Column Chart with dummy data, as shown in the screenshot below.

Line and Clustered Column Chart in Power BI 5

To add data to the Power BI Line and Clustered Column Chart, we have to add the required fields:

  • Shared Axis: Please specify the Column that represents the Vertical Axis.
  • Column Series: Specify the Column that represents the Clustered column Bars.
  • Column Values: Any Numeric value such as sales, profit, etc., that represent the Vertical bars.
  • Line Values: Any Numeric value that represents the Line.

Let me drag the Sales from Fields section to Column Values field and Region to Shared Axis Section.

Line and Clustered Column Chart in Power BI 6

Let me sort the data by Region. To do this, click on the … (3 dots) on the top right corner, and select the Sort By Region option as we showed below.

Line and Clustered Column Chart in Power BI 7

Next, add the Product Category to the Column Series section

Line and Clustered Column Chart in Power BI 8

Drag and Drop the Profit field into the Line Values section. That’s it; we got our Line and Clustered Column Chart.

Line and Clustered Column Chart in Power BI 9

Hover over any vertical bar shows you the Tool-tip of Region, Product Category, and Sales Amount.

Line and Clustered Column Chart in Power BI 10

Hover over any portion of a Line will show the Tool-tip of Region, and Profit.

Line and Clustered Column Chart in Power BI 11

Let me do some quick formatting to this Line and Clustered Column Chart

NOTE: I suggest you refer to Format Line and Clustered Column Chart article to understand the steps involved in formatting the Clustered columns, Lines, Title, etc.

Line and Clustered Column Chart in Power BI 12