Forum Discussion
Creating stacked chart from 4 different tables
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...
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.
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.
Thank you! That worked.