Forum Discussion
Relating 3 columns together in single table.
I have a single table that has three different Finish Dates. Actual Finish, Forecast Finish and Baseline Finish. All three are tied to an Activity ID. I am trying to get all three on to one line chart where the Y-axis is number remaining at a given date and x-axis is the date. I want them to lay on top of each other to show how close they are to being ontrack. I can get each graph to work by itself but I am unable to join all three. Below is a small sample. IS there a way to get the three columns to relate even though they need to be their own line on same graph.
| Activity ID | Actual Finish | Forecast Finish | BL Finish |
| ACT-Con-001 | 3/13/2022 | 3/13/2022 | 3/8/2022 |
| ACT-Con-002 | 3/14/2022 | 3/14/2022 | 3/11/2022 |
| ACT-Con-003 | 7/15/2022 | 7/15/2022 | 7/14/2022 |
| ACT-Con-004 | 11/15/2022 | 11/15/2022 | 11/16/2022 |
| ACT-Con-005 | 11/14/2022 | 11/1/2022 | 11/19/2022 |
| ACT-Con-006 | 1/19/2023 | 1/17/2023 | 1/22/2023 |
| ACT-Con-007 | 3/15/2023 | 3/20/2023 | 3/27/2023 |
| ACT-Con-008 | 5/18/2023 | 5/21/2023 | 5/30/2023 |
| ACT-Con-009 | 5/22/2023 | 5/22/2023 | 8/2/2023 |
| ACT-Con-010 | 9/28/2023 | 9/22/2023 | 10/5/2023 |
| ACT-Con-011 | 11/23/2023 | 11/23/2023 | 12/8/2023 |
| ACT-Con-012 | 1/24/2024 | 1/24/2024 | 2/10/2024 |
| ACT-Con-013 | 3/29/2024 | 3/26/2024 | 4/14/2024 |
| ACT-Con-014 | 6/1/2024 | 5/27/2024 | 6/17/2024 |
| ACT-Con-015 | 7/28/2024 | 8/20/2024 | |
| ACT-Con-016 | 9/28/2024 | 10/23/2024 | |
| ACT-Con-017 | 11/29/2024 | 12/26/2024 | |
| ACT-Con-018 | 1/30/2025 | 2/28/2025 | |
| ACT-Con-019 | 4/2/2025 | 5/3/2025 | |
| ACT-Con-020 | 6/3/2025 | 7/6/2025 |
It would be like the chart below but left is number of activities remaining and bottom in date. The yellow bar graph is not important.
Open Power Query Editor.
Select the columns Actual Finish, Forecast Finish, and BL Finish.
Right-click and choose "Unpivot Columns".
3 Replies
Open Power Query Editor.
Select the columns Actual Finish, Forecast Finish, and BL Finish.
Right-click and choose "Unpivot Columns".
