Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Yes, it is very much possible. But the tables need to be related to each other in the data model.
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.
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.
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.
Yes, it is very much possible. But the tables need to be related to each other in the data model.