Forum Discussion
Combine 2 tables data into one graph
Here is the 2 tables, kindle help me to combine to one graph
| Date | 28-Nov-20 | ||||
| Program | IN | Closed | WIP | Auto | Manual |
| G2G | 32 | 39 | 1 | 10 | 21 |
| R2O | 10 | 10 | 0 | 10 | 0 |
| HyperWan | 7 | 7 | 0 | 7 | 0 |
| SDWan | 0 | 0 | 0 | 0 | 0 |
| Monarch | 0 | 0 | 0 | 0 | 0 |
| Date | 5-Dec-20 | ||||
| Program | IN | Closed | WIP | Auto | Manual |
| G2G | 132 | 106 | 2 | 45 | 89 |
| R2O | 11 | 11 | 0 | 11 | 0 |
| HyperWan | 28 | 28 | 0 | 28 | 0 |
| SDWan | 0 | 0 | 0 | 0 | 0 |
| Monarch | 0 | 0 | 0 | 0 | 0 |
5 Replies
- vanessafvg
Community Champion
you can append these tables in power query because the structure is the same, just add a date column to each table with the relevant date before you append them
- Fowmy
Super User
You can do the necessary transformation in Power Query to combine the data for each day into one table, if you could share a sample in excel or CSV, I can show you the steps.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Here is teh 2 graphs which I prepared using 2 tables, need to combine into single chart.
- v-easonf-msft
Community Support
Hi, Varalakshmi123
How do you want to integrate the data from the two tables?
The data in the visual has line part and bar part. If you want to merge data from two different date tables into a single line and clustered column chart , most likely you will get a summary chart.
For your requirement ,you can consider using this custom visual Drill Down Combo PRO by ZoomCharts .
Best Regards,
Community Support Team _ Eason - v-easonf-msft
Hi, Varalakshmi123
Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread. If you still need help, please share more details to us.Best Regards,
Community Support Team _ Eason
