Problem with 3 table matrix

[Anonymous]

Hi!

I need a matrix where I can see the real headcount vs de budget, depending on the type of employee and group by their acoounts.

This are my 3 tables:

Real employees:

Account	Name	Año (year)	MONTH	Tipo (type)
2025015200	JUAN MANUEL	2021	12	Sindicalizado
2025015200	OSCAR IVAN	2021	12	Sindicalizado
2025015200	ALEJANDRO	2021	12	Sindicalizado
2025005400	ENRIQUE	2021	12	No Sindizado
2025005400	JOSE LUIS	2021	12	No Sindizado
2025015200	MANUEL RAUL	2021	12	No Sindizado
2025015200	LUIS MIGUEL	2021	12	No Sindizado
2025015200	MARIO	2021	12	No Sindizado
2025015200	YAN CARLOS	2021	12	No Sindizado
2025015200	VICTOR HUGO	2021	12	No Sindizado
2025015200	JUAN DANIEL	2021	12	No Sindizado
2025015200	LEONEL ALEJANDRO	2021	12	No Sindizado
2025015200	ALEXIS HERIBERTO	2021	12	No Sindizado
2025015200	ALDO	2021	12	No Sindizado
2025015200	OMAR GERARDO	2021	12	No Sindizado

The budget, depending on the type of employee:

Account	SINDICALIZADO	NO SINDICALIZADOS	Año (Year)
2025005400	3	0	2021
2025015200	8	3	2021
2025405248	1	0	2021
2025005400	3	0	2022
2025015200	8	3	2022
2025405248	1	0	2022

And the information about he accounts:

Account	CITY	UN
2022085200	Cuauhtémoc	RM
2025005400	Cuauhtémoc	RM
2025008623	Cuauhtémoc	RM
2025015200	Cuauhtémoc	RM
2025035200	Cuauhtémoc	RM
2025055200	Cuauhtémoc	RM
2025065200	Cuauhtémoc	RM
2025405248	Cuauhtémoc	RM

And i need a matrix that can be filter by:

• Year: same budget all year
• Month: the real emplooyes will modify each month
• Type of employee, so i can se 3 diferent scenarios as i show you next
• And expand the selection so i can see the names of the employees that are in the account

I used 2 slicer of the same name to show you the examples, but i need just one of each one.

Thanks!

[amitchandak]

@Anonymous , if you want the same slicer to work with different visuals, you can use interactions 

How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4

or use independent tables

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[Anonymous]

Thanks, but the problem is that when I use them like that, the matrix didn't work like I wish... it filters only the data of the employee, I mean, if I have no employee in an account, the matrix don't show me the budget of that account.