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".

     

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