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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
manojk_pbi
Helper IV
Helper IV

Stacked Bar Chart - Help

Hi,

 

I am trying to create a Stacked Column chart like below, I am not able to get it right. Any suggestions ?

Below chart should honour the selections based on Project or other dimensions. Another point how do we add Total on top of Bar and % of each value.

 

Sample Data

ProjectTypeBudgetForecastActual
P1PROD10010050
P2SERV15015025
P3SERV10010045
P4SERV25025025
P5PROD10010060
P6PROD12012080
P7PROD250250150
P8PROD20020090

Output

manojk_pbi_0-1715927353546.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Your data is not in a usable format. Unpivot it.

 

lbendlin_0-1715952719527.png

Then enable Totals labels

lbendlin_1-1715952812335.png

Then create a percentage measure and add it to the Detail area

lbendlin_2-1715953016208.png

 

Careful, you risk trying to do too much. Make sure your users understand the visual.

 

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Your data is not in a usable format. Unpivot it.

 

lbendlin_0-1715952719527.png

Then enable Totals labels

lbendlin_1-1715952812335.png

Then create a percentage measure and add it to the Detail area

lbendlin_2-1715953016208.png

 

Careful, you risk trying to do too much. Make sure your users understand the visual.

 

 

Thanks @lbendlin  for the solution. This is exactly what i am looking. 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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