Forum Discussion
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
| 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
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.
2 Replies
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.
Thanks lbendlin for the solution. This is exactly what i am looking.
