Struggling to create visual

[GarethParry]

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

[HotChilli]

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.