Forum Discussion
OneWithQuestion
Post Prodigy
9 years agoPossible 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. In this example I have sales or r...
Anonymous
9 years agoNot applicable
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.
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