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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
FrankWe
Helper II
Helper II

Create Stacked Bar Chart with values from 4 measures

Hello,

 

I need to create a Stacked Bar Chart that uses values from four measures. The chart should look like this:

 

FrankWe_0-1715767457865.png

 

The four values you can see in the chart (24232, 9465, 4404 and 19481) are values calculated by 4 different measures. Is there a way to create such a stacked bar chart based on measures?

 

I tried to create this with calculation group but the result (see screenshot below) is not what I would like to have. 

FrankWe_1-1715767682487.png

Frank

1 ACCEPTED SOLUTION
nandic
Super User
Super User

@FrankWe 
To make it dynamically (on 1 chart) you would need calculated column in main table which sets if row is relevant for Vol or GM.
Then you would use that column as X axis and in values you would add all 4 measures and then enable labels and total labels.
If it can't be that dynamic, that i suggest creating 2 different visuals, one showing only Vol measures, another showing only GM values and then just rename X axis.
Remove titles from these two charts and add one text box centered above both of them as main title.

A little bit of work, but it will work.

Cheers,
Nemanja Andic

View solution in original post

1 REPLY 1
nandic
Super User
Super User

@FrankWe 
To make it dynamically (on 1 chart) you would need calculated column in main table which sets if row is relevant for Vol or GM.
Then you would use that column as X axis and in values you would add all 4 measures and then enable labels and total labels.
If it can't be that dynamic, that i suggest creating 2 different visuals, one showing only Vol measures, another showing only GM values and then just rename X axis.
Remove titles from these two charts and add one text box centered above both of them as main title.

A little bit of work, but it will work.

Cheers,
Nemanja Andic

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors