Showing results for 
Search instead for 
Did you mean: 
New Member

Stacked 100% Column Chart with different values

Hi All,


I'm working on a very simple graph the ideal output would be one  100% stacked bar chart with two bars : One Bar showing me count of the column, the second showing me the sum of it. In the dataset I have 4 stores A,B,C & D and each brand is labeled as Best, Better or Good. In the bar I would be showing the breakdown by these labels for both count and sum. Since I'm unable to select to show both count and sum together, I have created another chart and made everything but the bar invisible in the second graph. This was my temporary solution but it would be great to have both these bars in one chart. Let me know what I can do. Thanks!








Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors