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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
manojk_pbi
Helper III
Helper III

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors