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.
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:
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.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |