how to combine multiple data sources, measures into one data set to use as a stacked bar chart.

[helpwithpowerbi]

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.

[amitchandak]

@helpwithpowerbi , 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-soluti...

Append Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15

[helpwithpowerbi]

data type is text which i am performing a countifs equivalent measure 4 times on to produce a number. It's these numbers i want to pull as a live connection together to create the chart from

[christinepayton]

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. 

[helpwithpowerbi]

WHen I tried doing this earlier custom columns werent pulled through when the tables were apended. Any tips on how to do this?

[christinepayton]

They come through. Make sure they are named the same between tables if you want them to line up together in the final table and that your append step is after the step where the columns are created. 🙂