Create and use combo charts in Power BI

APPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service

In Power BI, a combo chart is a single visualization that combines a line chart and a column chart. Combining the 2 charts into one lets you make a quicker comparison of the data.

Combo charts can have one or two Y axes.

When to use a Combo chart

Combo charts are a great choice:

  • when you have a line chart and a column chart with the same X axis.
  • to compare multiple measures with different value ranges.
  • to illustrate the correlation between two measures in one visualization.
  • to check whether one measure meet the target which is defined by another measure
  • to conserve canvas space.


Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.


This tutorial uses the Retail Analysis Sample PBIX file.

  1. From the upper left section of the menubar, select File > Open report

  2. Find your copy of the Retail Analysis Sample PBIX file

  3. Open the Retail Analysis Sample PBIX file in report view .

  4. Select to add a new page.

Create a basic, single-axis, Combo Chart

Watch Will create a combo chart using the Sales and Marketing sample.


This video might use earlier versions of Power BI Desktop or the Power BI service.

  1. Start on a blank report page and create a column chart that displays this year's sales and gross margin by month.

    a. From the Fields pane, select Sales > This Year Sales > Value.

    b. Drag Sales > Gross Margin This Year to the Value well.

    c. Select Time > FiscalMonth to add it to the Axis well.

    Combo tutorial example.

  2. Select More options (...) in the upper-right corner of the visualization, and select Sort by > FiscalMonth. To change the sort order, select the ellipsis again and choose either Sort ascending or Sort descending. For this example, use Sort ascending.

  3. Convert the column chart to a combo chart. There are two combo charts available: Line and stacked column and Line and clustered column. With the column chart selected, from the Visualizations pane select the Line and clustered column chart.

    Convert combo chart example.

  4. From the Fields pane, drag Sales > Last Year Sales to the Line Values bucket.

    Line values area showing Last Year Sales.

    Your combo chart should look something like this:

    Combo chart done example.

Create a combo chart with two axes

In this task, we'll compare gross margin and sales.

  1. Create a new line chart that tracks Gross Margin Last Year % by FiscalMonth. Select the ellipsis to sort it by FiscalMonth and choose Sort ascending.

    In January GM% was 35%, peaked at 45% in April, dropped in July and peaked again in August. Will we see a similar pattern in sales last year and this year?

    Combo chart example sales.

  2. Add This Year Sales > Value and Last Year Sales to the line chart. The scale of Gross Margin Last Year % is much smaller than the scale of Sales which makes it difficult to compare.

    Combo chart flatline example.

  3. To make the visual easier to read and interpret, convert the line chart to a Line and stacked column chart.

    Convert to combo chart example.

  4. Drag Gross Margin Last Year % from Column Values into Line Values. Power BI creates two axes, thus allowing the datasets to be scaled differently; the left measures sales dollars and the right measures percentage. And we see the answer to our question; yes, we do see a similar pattern.

    Cluster combo chart example.

Add titles to the axes

  1. Select the paint roller icon to open the Formatting pane.

  2. Select the down arrow to expand the Y-axis options.

  3. For Y-Axis (Column), set Position to Left, set Title to On, Style to Show title only, and Display units as Millions.

    Combo chart open y example.

  4. Under Y-Axis (Column), scroll down until you see Show secondary. Because there are so many options for the Y axes, you may have to use both scrollbars. The Show secondary section displays options for formatting the line chart portion of the combo chart.

    Combo chart secondary example.

  5. For Y-Axis (Line), leave Position as Right, turn Title to On, and leave Style as Show title only.

    Your combo chart now displays dual axes, both with titles.

    Combo chart titles example.

  6. Optionally, modify the text font, size, and color and set other formatting options to improve the display and readability of the chart.

From here you might want to:

Cross-highlighting and cross-filtering

Highlighting a column or line in a combo chart cross-highlights and cross-filters the other visualizations on the report page... and vice versa. Use visual interactions to change this default behavior.

Considerations and limitations

Depending on the size of your combo chart, the data labels may or may not display. If you don't see data labels, resize the combo chart.

Next steps

Doughnut charts in Power BI

Visualization types in Power BI