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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
21 | |
6 | |
3 | |
3 | |
3 |