Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.