cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Possible to make a Combo Chart? (Like in Excel)

I don't see a way to do this, but wanted to make sure I wasn't just missing something obvious?

 

I want to make a clustered bar chart, but with two axis.

 

ComboChartExample.pngIdeal Example

In this example I have sales or revenue as the wider blue bar and then expenses/costs as the smaller stacked bars inside.

 

Making it very easy to see if expenses exceeded revenues and the main three expense categories.

 

Then I threw profit on as a line.

 

Is there anyway to do this in PowerBI?

 

Specifically, the clustered bar charts with the outer bar being one measure (revenue) and the inner bars being expenses so you can see how they stack up?

 

Thanks!

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Possible to make a Combo Chart? (Like in Excel)

Hi @OneWithQuestion,

Based on my test, in Power BI, it is not possible to create the same visual like that in Excel. You can create a line and clustered column chart as shown in the following screenshot, drag revenues field and expense field into Column values , drag profit into Line values.
1.PNG


In this visual , it is easy for you to see if expenses exceeded revenues, however, it is impossible to classify the expenses, because it doesn’t allow you to drag category field into Column series once you have two fields in Column values. And when you firstly drag category field into Column series, it only allows you to drag one field into Column value.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 36 members 969 guests
Please welcome our newest community members: