Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.