Forum Discussion
Helper VBring/Combine 2 dates on the same column
Hi,
I have a sample data that looks like this:
| Opportunity ID | HW Date | Hardware Order($M) | SW Date | Software Order($M) |
| OPE123 | 1/1/2021 | 45 | 1/1/2021 | 70 |
| OPE124 | 1/8/2021 | 30 | 1/10/2021 | 13 |
| OPE125 | 1/8/2021 | 96 | 1/10/2021 | 23 |
| OPE126 | 1/8/2021 | 33 | 1/11/2021 | 39 |
| OPE127 | 1/8/2021 | 46 | 1/11/2021 | 70 |
| OPE128 | 1/6/2021 | 98 | 1/11/2021 | 58 |
| OPE129 | 1/9/2021 | 68 | 1/12/2021 | 36 |
| OPE130 | 1/9/2021 | 22 | 1/12/2021 | 100 |
| OPE131 | 1/9/2021 | 63 | 1/13/2021 | 100 |
| OPE132 | 1/9/2021 | 41 | 1/13/2021 | 68 |
| OPE133 | 1/11/2021 | 42 | 1/13/2021 | 44 |
| OPE134 | 1/12/2021 | 42 | 1/13/2021 | 67 |
| OPE135 | 1/13/2021 | 62 | 1/13/2021 | 88 |
| OPE136 | 1/14/2021 | 55 | 1/14/2021 | 97 |
| OPE137 | 1/15/2021 | 37 | 1/15/2021 | 18 |
| OPE138 | 1/16/2021 | 24 | 1/16/2021 | 80 |
| OPE139 | 1/17/2021 | 17 | 1/17/2021 | 51 |
Using this data I want to visualize data that looks something like this:
HW and SW should be on the same axis with drill down till week level.
But the issue is the dates are not on the same axis, meaning, there are different columns for hardware and software
Some dates are missing in HW and some are missing in SW.
How can i bring them on a common date axis and then use that to visualize my data?
Some transformations are required in power query, please download my sample pbix and check applied step in query editor.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
Some transformations are required in power query, please download my sample pbix and check applied step in query editor.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Hi klehar
You can maybe go back to Power Query, duplicate your table : you will have two same tables. In the fisrt one you only keep SW information, rename the columns Software Order($M) as Order Value($M) and SW Date as Date, and you add a column named OrderType (each value = "SW"). In the other one you do the same thing but for HW. Finally you append the wo queries.
You will have then only to apply the changes and use the new table : put OrderType in Legend, Order Value($M) in Value and Date in X axis.
Please accept it as a solution if it solved your issue