Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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,
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,
Hi Cherie,
That's perfect, thank you.
User | Count |
---|---|
88 | |
88 | |
73 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |