Chart on multiple dates

Question

Hi everyone,I have two tables that are formatted as follows:First one is for planned components:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ComponentQtyDate RequiredA11/12/2019B11/11/2019A11/10/2019C11/09/2019&nbsp;The other for unplanned (extrapolated):ComponentQty1st Change2nd Change3rd Change…..A11/12/20191/12/20201/12/2021&nbsp;B21/11/20191/11/20201/11/2021&nbsp;A21/10/20191/10/20201/11/2021&nbsp;C11/09/20191/09/20201/09/2021&nbsp;&nbsp;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)&nbsp; &nbsp; &nbsp;.&nbsp;&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |Qtr 1 2019&nbsp; &nbsp;Qtr 2 2019&nbsp; &nbsp;Qtr 3 2019Or something to that effect.Appreciate any help.

v-cherch-msft · Accepted Answer

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

Regards,

Forum Discussion

Chart on multiple dates

2 Replies

Related content

Multiple Date Fields

Multiple Donut charts with conditions

Multiple line and clustered columns chart

Date Relationships - Multiple Tables, Multiple dates.

Ribbon chart data by date

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

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