Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Varalakshmi123
New Member

Combine 2 tables data into one graph

Here is the 2 tables, kindle help me to combine to one graph

Date28-Nov-20    
ProgramINClosedWIPAutoManual
G2G323911021
R2O10100100
HyperWan77070
SDWan00000
Monarch00000

 

Date5-Dec-20    
ProgramINClosedWIPAutoManual
G2G13210624589
R2O11110110
HyperWan28280280
SDWan00000
Monarch00000
5 REPLIES 5
v-easonf-msft
Community Support
Community Support

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
Community Support
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  .

 

82.png

 

Best Regards,
Community Support Team _ Eason

Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

 

Varalakshmi123_0-1607434573695.png

 

Varalakshmi123_1-1607434608258.png

 

vanessafvg
Super User
Super User

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors