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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
helpwithpowerbi
New Member

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:

 

helpwithpowerbi_0-1697157637602.png

Any help or ideas are very appreciated.

5 REPLIES 5
amitchandak
Super User
Super User

@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

 

 

 

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

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. 

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors