Combo Chart in Power (Tutorial)
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.
Create a basic, single-axis, Combo Chart
Watch Will create a combo chart using the Sales and Marketing sample.
To create your own combo chart, sign in to Power BI and select Get Data > Samples > Retail Analysis Sample.
- From the "Retail Analysis Sample" dashboard, select the Total Stores tile to open the "Retail Analysis Sample" report.
- Select Edit Report to open the report in Editing View.
- Add a new report page.
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.
- Select the ellipses (...) in the upper-right corner of the visualization, and select Sort by FiscalMonth.
Convert the column chart to a combo chart. With the column chart selected, from the Visualizations pane select the Line and clustered column chart.
From the Fields pane, drag Sales > Last Year Sales to the Line Values bucket.
Your combo chart should look something like this:
Create a combo chart with two axes
In this task, we'll compare gross margin and sales.
Create a new line chart that tracks Gross Margin % last year by Month. 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?
Add This Year Sales > Value and Last Year Sales to the line chart. The scale of GM% Last Year is much smaller than the scale of Sales which makes it difficult to compare.
To make the visual easier to read and interpret, convert the line chart to a Line and Stacked Column chart.
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 dollars and the right measures percentage.
Add titles to the axes
- Select the paint roller icon to open the Formatting pane.
- Select the down arrow to expand the Y-axis options.
For Y-Axis (Column), set Position to Left, set Title to On, Style to Show title only, and Display as Millions.
Under Y-Axis (Column) also ensure that Show Secondary is set to On. This displays options for formatting the line chart portion of the combo chart.
For Y-Axis (Line), leave Position as Right, turn Title to On, and set Style to Show title only.
Your combo chart now displays dual axes, both with titles.
From here you might want to:
Highlighting and cross-filtering
For information about using the Filters pane, see Add a filter to a report.
Highlighting a column or line in a combo chart cross-filters the other visualizations on the report page... and vice versa.
More questions? Try the Power BI Community