Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
3 |