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 in Power BI, first Drag and Drop the Sales from Fields section to Canvas region. It automatically creates a Column Chart, as we have shown below.
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.
Let me add Region to Shared Axis section, and Profit to Line Values section to convert it into the Line and Clustered Chart.
Next, we are adding Customer Segment to the Column Series section to convert it into the Clustered Column.
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.
To add data to the Power BI Line and Clustered Column Chart, we have to add the required fields:
- Shared Axis: Please specify the one that represents the Vertical Axis.
- Column Series: Specify the one 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.
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.
Next, add the Product Category to the Column Series section
Drag and Drop the Profit field into the Line Values section. That’s it; we got our Line and Clustered Column Chart.
Hover over any vertical bar shows you the Tool-tip of Region, Product Category, and Sales Amount.
Hover over any portion of a Line will show the Tool-tip of Region, and Profit.
Let me do some quick formatting to this Line and Clustered Column Chart
NOTE: I suggest you refer to Format Line and Clustered Chart article to understand the steps involved in formatting the Clustered cols, Lines, Title, etc.
