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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Rigby16
Regular Visitor

Creating 1 visual from 5 different tables

Hi,

 

I have 5 different tables, 5 worksheets in 1 excel file. i've uploaded this to power BI as data set. Is it possible to combine the data from these 5 worksheets into 1 visual? for example clustered columns visual, each cluster will be composed of 5 columns from 5 worksheets.

 

Thanks!

 

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Yes, it is very much possible. But the tables need to be related to each other in the data model.

View solution in original post

Hi @Rigby16 ,

 

You can try append query in power query editor. This function allows you to combine mang tables with the same structure.

vchenwuzmsft_0-1649924315898.png

For more details you can check it in this link.

Append queries - Power Query | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Rigby16
Regular Visitor

Thank you Aditya for the advise. This is my first time doing data model as i usually use 1 table for power BI. I tried to make relationships between the tables however it requires to use many-to-many. When I tried creating the cluster columns visual the value was not seggrerated but it reflects the total number of tickets in the table and not in a per month basis.  😞

just to give a description of the tables, the 5 tables consists of same columns with data from different sites: ticket number, date, severity, status. i want to show in a cluster column the number of tickets per month per site.

thanks!

Hi @Rigby16 ,

 

You can try append query in power query editor. This function allows you to combine mang tables with the same structure.

vchenwuzmsft_0-1649924315898.png

For more details you can check it in this link.

Append queries - Power Query | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Yes, it is very much possible. But the tables need to be related to each other in the data model.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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