Creating 1 visual from 5 different tables

[Rigby16]

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!

[Anonymous · Accepted solution]

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

[Rigby16]

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.  😞

[Rigby16]

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!

[v-chenwuz-msft · Accepted solution]

Hi @Rigby16 ,

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

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 · Accepted solution]

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