Merge 2 tables for a Matrix Visualisation where second table is unaffected by Filters and Slicers

[GopVan]

I have 2 tables:

1. Events Data - Contains monthly data so I have generated a start date and end date. 

2. Critical Period Data - Has specific start and end dates and applicable organization-wide. 

I have a Matrix visualization with Events Data (link provided). Now I want to add Critical period rows to the same Matrix Visual such that the rows are always visible and unaffected by slicers. 

Position and Directorate are "All" for Critical periods as they are applicable to the entire organization.

ID	Position	Directorate	Interaction	Interaction Year	Interaction Month
1	Officer	Information Technology	IT Equipment Review	2023	January
2	Scheduling Officer	Academics	Conference Scheduling	2023	February
3	Research	Academics	Genome Research	2023	January
4	Co-Ordinator	Marketing	Events Co-ordination	2023	March
5	Manager	Marketing	Promotion Event	2023	April
6	Co-Ordinator	Information Technology	Meeting Co-Ordinator	2023	May
7	Manager	Academics	Review and Consolidation	2023	May
8	Co-Ordinator	Marketing	Feedback Collection	2023	June
9	Manager	Strategy	Workshop -1	2023	June
10	Manager	Strategy	Workshop -2	2023	July
11	Officer	Strategy	Risk Register	2023	August
12	Manager	Academics	Contract Updation	2023	September
13	Officer	Marketing	Promotion Feedback	2023	October
14	Research	Academics	Lifestyle Research	2023	October
15	Officer	Marketing	Feedback Publishing	2023	November

ID	Critical Period	Start Date	End Date
1	Critical Period 1	13/02/2023	10/03/2023
2	Critical Period 2	10/04/2023	21/04/2023
3	Critical Period 3	5/06/2023	23/06/2023
4	Critical Period 4	17/07/2023	11/08/2023
5	Critical Period 5	25/09/2023	6/10/2023
6	Critical Period 6	6/11/2023	24/11/2023

The link to the pbix file is below:

PBIX FILE MATRIX VISUAL 

[v-xiaosun-msft]

Hi @GopVan ,

You can use "merge as new" in Power Query.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.