Forum Discussion
GarethParry
Helper I
Helper IStruggling to create visual
Hi,
We have the below graph in excel, but i cant create in Power BI. Its bascially a stacked column chart for starters and leavers year to date.
i have a table that summarises leavers as
| Leavers | Site | Month | Year |
| 45 | Nottingham | Apr | 2022 |
| 35 | Leeds | Apr | 2022 |
| 345 | Central | Apr | 2022 |
| 72 | Nottingham | Aug | 2022 |
| 78 | Leeds | Aug | 2022 |
| 252 | Central | Aug | 2022 |
| 11 | Peterborough | Aug | 2022 |
and a table that summarises new starters
| Starters | Site | Month | Year |
| 10 | Gateshead | Apr | 2022 |
| 35 | Nottingham | Apr | 2022 |
| 45 | Leeds | Apr | 2022 |
| 30 | Peterborough | Apr | 2022 |
| 120 | Central | Apr | 2022 |
| 15 | Gateshead | Aug | 2022 |
| 30 | Leeds | Aug | 2022 |
| 18 | Nottingham | Aug | 2022 |
| 69 | Central | Aug | 2022 |
| 13 | Peterborough | Aug | 2022 |
and want something like
is this possible?
thanks
Gareth
1 Reply
- HotChilli
Community Champion
I think I would Append those tables (Add a column- "Type" to each with a hardcoded value of "Leavers" or "Starters" then rename 1st column in each to be "NumPeople" ).
You can then use a stacked column chart.
