Relating 3 columns together in single table.

[PeteyG]

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.

[aduguid · Accepted solution]

Open Power Query Editor.

Select the columns Actual Finish, Forecast Finish, and BL Finish.

Right-click and choose "Unpivot Columns".

[PeteyG]

Awesome that puts them all into a related single Column.  Any idea how I now make three lines with them onto a single line chart?  It now groups them into one line.

[aduguid]

Add the finish type (Actual, Forecast, and Baseline), as the legend of the chart