Forum Discussion
how to combine multiple data sources, measures into one data set to use as a stacked bar chart.
Hi,
I have a fair bit of experience using powerbi service but have just started trying to use powerbi desktop to automate some of my exsiting reports. I have one where I have aprox 15 sharepoint lists that ive connected, and I need to analyse and count how many items meet 4 specific groupings (quite easy to do in excel with countifs and have managed to do it in powerBI too with help from google).
I now want to be able to combine all these into one data set where I have the "source" column first, then count 1, count 2, count 3, count 4 as the other columns. This is to be used as a stacked barchart. such as below:
Any help or ideas are very appreciated.
5 Replies
- amitchandak
Super User
Anonymous , Depending on type of data
1. Create common dimension
2. Append or merge data
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaAppend Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15- christinepayton
Most Valuable Professional
The poster above is correct, you'd need to append your tables. Before you append, you can create a custom column with the text label you want to show in each to use in the visual as the legend.
