How to Create and Use Power BI Combo Chart?

In this Power BI tutorial, we will learn what is a Power BI Combo chart, different types of combo charts in Power BI, and how to work with a Power BI combo chart multiple lines with examples.

Apart from that, we will discuss some more topics below:

  • Power BI line and clustered column chart multiple lines
  • Power BI line and clustered column chart secondary axis
  • Power BI line and stacked column chart secondary axis
  • Power BI line and clustered column chart remove secondary axis
  • Power BI line and stacked column chart remove secondary axis
  • Power BI combo chart line legend
  • Power BI combo chart data label
  • Power BI combo chart area and line

What is a Combo Chart in Power BI

Combo chart in Power BI is a combination of a line chart and a column chart. It allows us to make quicker decisions. This chart can have one or two axes.

There are two types of combo charts in Power BI:

  • Line and Stacked column chart
  • Line and Cluster column chart

How to create a combo chart in Power BI

To create a combo chart in Power BI, follow the steps below:

We will use the Sales Excel data to create a combo chart, i.e., a Line and Stacked column chart and a Line and Cluster column chart in Power BI.

power bi combo bar

Power BI Line and Stacked column chart

  • Open Power BI Desktop, then select the Excel workbook from the ribbon and load the data.
  • To create a Line and Stacked column chart, select it from the visualization pane.
combo chart in power bi
  • Then drag and drop the Product Category, sales, and Profit to the X-axis, Column y-axis, and Line y-axis.
  • The sum of sales and profit by product category can now be seen in the Power BI line and stacked column chart.
What is combo chart in Power BI

Power BI Line and Cluster column chart

  • Select the Line and Cluster column chart from the visualization pane in Power BI Desktop.
  • Then drag and drop the Product Category, sales, and Profit to the X-axis, Column y-axis, and Line y-axis.
  • Now you can see the Sum of sales and Sum of profit by product category in the Power BI line and clustered column chart.
power bi combo chart

Power BI combo chart multiple lines

Here, we will see how to create a combo chart with multiple lines.

See also  Power Apps Column Chart - How to Build it

To create a combo chart with multiple lines, we will use the Sales table in Power BI.

power bi combo bar

Power BI line and clustered column chart multiple lines

  • In Power BI Desktop, load the data using the Get Data option.
  • To create a Line and clustered column chart, select it from the visualization pane.
Power BI combo chart multiple lines
  • Then drag and drop the Product Category, sales, Profit, Quantity, and COGS to the X-axis, Column y-axis, and Line y-axis.
  • Now you see the multiple lines in the Power BI line and clustered column chart.
Power BI line and clustered column chart multiple lines

Power BI line and stacked column chart multiple lines

  • In Power BI Desktop, load the data using the Get Data option.
  • To create a Line and Stacked column chart, select it from the visualization pane.
combo chart in power bi
  • Then drag and drop the Product Category, sales, Profit, Quantity, and COGS to the X-axis, Column y-axis, and Line y-axis.
  • Now you see the multiple lines in the Power BI line and stacked column chart.
Power BI line and stacked column chart multiple lines

This is how we can add multiple lines in the Power BI combo chart.

Power BI line and clustered column chart secondary axis

Here, we will see how to show the secondary axis in the Power BI Cluster column chart.

In this example, we will use the Sales table to create a Line and cluster column chart in Power BI and add the secondary axis to the visual.

power bi secondary axis

To show the secondary axis in the Power BI Line and cluster column chart, follow the below steps:

  • In Power BI Desktop, load the data using the get data option.
  • To create a Power BI Line and cluster column chart, select it from the Visualization pane.
  • Then, drag and drop the Product Category, Sales, and COGS to the X-axis, Column Y-axis, and Line Y-axis.
power bi secondary axis chart
  • Select the visual and then the format icon. Expand the Secondary Y-axis section. Turn on Values, and you can format the values according to your requirements.
power bi combo
  • Now you can see the Secondary Y-axis in the Power BI Line and cluster column chart.
Power BI line and clustered column chart secondary axis

This is how we can create a line and clustered column chart secondary axis in Power BI.

Power BI line and stacked column chart secondary axis

Here, we will see how to show the secondary axis in the Power BI stacked column chart.

In this example, we will use the Sales table to create a Line and stacked column chart in Power BI and add the secondary axis to the visual.

dual axis line chart power bi

Follow the below steps to show the secondary axis in the Power BI line and stacked column chart.

  • In Power BI Desktop, load the data using the get data option.
  • To create a Power BI Line and stacked column chart, select it from the Visualization pane.
  • Then, drag and drop the Product Category, Sales, and COGS to the X-axis, Column Y-axis, and Line Y-axis.
combo chart power bi

Select the visual and then the format icon. Expand the Secondary Y-axis section. Turn on Values, and you can format the values according to your requirements.

power bi line and stacked column chart align y axis
  • Now you can see the Secondary Y-axis in the Power BI Line and stacked column chart.
Power BI line and stacked column chart secondary axis

This is an example to show the secondary axis in the Power BI line and stacked column chart.

See also  Power Automate toLower() Function [How to Use]

Power BI line and clustered column chart remove secondary axis

Here, we will see how to remove the secondary axis in the Power BI line and cluster column chart.

For example, we have the Power BI line and clustered column chart below, and we will remove the secondary axis.

Power BI line and clustered column chart remove secondary axis

To remove the secondary Y-axis from the line and cluster column chart, follow the below steps:

  • Select the visual and then click on the Format pane and expand the Secondary Y-axis. Toggle the Values section.
power bi remove secondary y axis

Now you can see the Power BI line and cluster column chart secondary axis is removed.

Power BI line and stacked column chart remove secondary axis

This is how we can remove the secondary axis in the Power BI line and clustered column chart.

Power BI line and stacked column chart remove the secondary axis

Here, we will see how to remove the secondary axis in the Power BI line and stacked column chart.

For example, we have the below Power BI line and stacked column chart, and we will remove the secondary axis.

turn off secondary y axis power bi

To remove the secondary Y-axis from the line and stacked column chart, follow the below steps:

  • Select the visual and then click on the Format pane and expand the Secondary Y-axis. Toggle the Values section.
power bi remove secondary y axis

Now you can see the Power BI line and stacked column chart secondary axis is removed.

Power BI line and stacked column chart remove the secondary axis

This is how we can remove the secondary axis in the Power BI line and stacked column chart.

Power BI combo chart line legend

Here, we will see how to show the line legend in the Power BI combo chart.

In this example, we will take a Sales table and create a line and stacked column chart. Then, we will enable the legend to show a line legend.

line and clustered column chart in power bi

To enable the legend in the combo chart [Line and Stacked column chart], follow the below steps

  • In Power BI Desktop, load the data using the get data option.
  • To create a Power BI Line and stacked column chart, select it from the Visualization pane.
  • Then, drag and drop the Product Category, Sales, and COGS to the X-axis, Column Y-axis, and Line Y-axis.
combo chart
  • Select the visual, then click the Format pane and toggle on the Legend.
  • You can see the Line legend in the Power BI Combo chart, i.e., the Line and Stacked column chart.
Power BI combo chart line legend

This is an example to show a line legend in the Power BI combo chart.

See also  How to Highlight the Selected Item within a Power Apps Gallery?

Power BI combo chart data label

Here, we will see how to enable the data label in the Power BI Combo chart.

In this example, we will take the sales table and then create a combo chart line and cluster column chart. Then, we will enable the data label, and you can see the combo chart below.

Power BI combo chart data label

To enable the data label in the combo chart [Line and Stacked column chart], follow the below steps

  • In Power BI Desktop, load the data using the get data option.
  • To create a Power BI Line and stacked column chart, select it from the Visualization pane.
  • Then, drag and drop the Product Category, Sales, and COGS to the X-axis, Column Y-axis, and Line Y-axis.
line and clustered column chart power bi
  • Select the visual, then click on the Format pane and toggle on the Data labels.
  • You can see the data labels in the Power BI Combo chart, i.e., Line and Cluster column chart.
Power BI combo chart data labels

This is an example of a Power BI combo chart to show data labels.

Power BI combo chart area and line

Here, we will see how to create a combo chart area and line in Power BI.

In this example, we will take the Sales list and create a combo chart with areas and lines.

As Power BI does not provide combo charts like area and line charts, we will take the Line chart and enable the Shaded area option in the Format pane to create the combo area and line chart. It will look like below.

combo charts in power bi

To create a combo chart area and line, follow the below steps:

  • In Power BI Desktop, load the data using the get data option.
  • Then, select the Line chart from the visualization pane to create a combo area and line chart.
  • Then, drag and drop the Product Category, Sales, and COGS to the X-axis, Y-axis, and Secondary Y-axis.
power bi secondary y axis
  • Select the visual, click on the Format icon, then toggle on the Shaded area option.
  • You can see the combo line and area chart in Power BI
Power BI combo chart area and line

This is an example of a Power BI combo chart area and line.

Moreover, you may like some more Power BI articles:

Conclusion

In this Power BI tutorial, we saw how to create a combo chart in Power BI and how to add multiple lines and a secondary y-axis to it.

Moreover, we have covered topics below

  • Power BI combo chart line legend
  • Power BI combo chart data label
  • Power BI combo chart area and line
>