Stacked Bar Chart - Help

[manojk_pbi]

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

Project	Type	Budget	Forecast	Actual
P1	PROD	100	100	50
P2	SERV	150	150	25
P3	SERV	100	100	45
P4	SERV	250	250	25
P5	PROD	100	100	60
P6	PROD	120	120	80
P7	PROD	250	250	150
P8	PROD	200	200	90

Output

[lbendlin · Accepted solution]

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

Then enable Totals labels

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

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

[manojk_pbi]

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