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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.