Creating stacked chart from 4 different tables

[dcasana]

Hi, 

I am creating a Power BI report using data from 4 different tables. Each table contains data for a different category - for instance, one table has data for all BLUE items, another table has data for all RED items, etc. There isn't a column that says BLUE or RED, but every line on each table pertains to that category.

I need to create a stacked chart that on the Y axis shows the different categories (BLUE, RED, etc.), and on the X axis shows the status of each category (i.e., blue open/closed, red open/closed, etc.)

Is this possible? I'm having trouble with what to put on the Y axis to accomplish this. I already have the counts of open/closed for each category on the X axis. I'm just stuck as to what to put on the Y axis. Thank you!

[CoreyP · Accepted solution]

You should add a column in Power Query to each table with the value of the category. So, new column: Category = "Blue". Do this so each table now has a column called Category with the appropriate value in the column. Then append all the tables so you have one table with all data and a column called category.

[dcasana]

Thank you! That worked.