Chart on multiple dates

[DrHematite]

Hi everyone,

I have two tables that are formatted as follows:

First one is for planned components:                                       

Component	Qty	Date Required
A	1	1/12/2019
B	1	1/11/2019
A	1	1/10/2019
C	1	1/09/2019

The other for unplanned (extrapolated):

Component	Qty	1st Change	2nd Change	3rd Change	…..
A	1	1/12/2019	1/12/2020	1/12/2021
B	2	1/11/2019	1/11/2020	1/11/2021
A	2	1/10/2019	1/10/2020	1/11/2021
C	1	1/09/2019	1/09/2020	1/09/2021

I need to be able to visualise all of these in the same chart with dates as the axis.
Have managed to link them via a date table, but can only get 1st change in the same chart.
Essentially would like
(. unplanned, | planned)

     . 

     .

     .                                         .

     |                      .                  .

     |                      |                  .

     |                      |                  |

Qtr 1 2019   Qtr 2 2019   Qtr 3 2019

Or something to that effect.

Appreciate any help.

[v-cherch-msft · Accepted solution]

Hi @DrHematite 

You may use 'Unpivot columns' for 1st change,2nd Change...columns in query editor.Then you may link the date table with the two tables to get the visual.

Regards,

[DrHematite]

Hi Cherie,

That's perfect, thank you.