Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Combo Charts- stacked and clustered intermixed?

I have the need to do a combo chart that has bars (or area) but allows me to set one axis to stacked and the other to clustered.

 

I want to show overall sales on one axis, and then under it I want to show breakdowns by areas.  So each area should stack.

 

Another example might be charting profits.

 

I want one bar to be revenue, and then another series be stacked expenses.  If those expenses stack up to be "shorter" than revenue, well then profit hurray!

 

If they stack TALLER than revenue...well we had a loss.

 

This is very easy to do in Excel but I still cannot seem to find anyway to accomplish this in Power BI?

2 REPLIES 2
v-xjiin-msft
Solution Sage
Solution Sage

Hi @OneWithQuestion,

 

I'm not quite understand about your requirement. Could you please share us some screenshots about it? Like your expected chart in Excel.

 

Thanks,
Xi Jin.

Ah of course:

 

Ideal ExampleIdeal Example

 

 

A similar setup:

Clustered Bars overlapping with lineClustered Bars overlapping with line

 *To be clear the 2nd example is not as ideal as it does not have stacked bars.

 

 

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.