Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |