Forum Discussion

PeteyG's avatar
PeteyG
Icon for Helper I rankHelper I
2 years ago
Solved

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 c...
Need Help
  • aduguid's avatar
    aduguid
    2 years ago

     

    Open Power Query Editor.

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

    Right-click and choose "Unpivot Columns".

     

PeteyG's avatar
PeteyG
Icon for Helper I rankHelper I
2 years ago

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's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

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