Combine 2 tables data into one graph

[Varalakshmi123]

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

[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

[v-easonf-msft]

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

[Fowmy]

@Varalakshmi123 

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 🙂

Website YouTube  LinkedIn

[Varalakshmi123]

Here is teh 2 graphs which I prepared using 2 tables, need to combine into single chart.

[vanessafvg]

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

https://docs.microsoft.com/en-us/power-query/append-queries