Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |