How to Combine Monthly Data in Separate Tables to Show in a Stacked Chart

[Anonymous]

Hi Community, I have three tables named 'October', 'November', and 'December'. All three tables are identical (in # of rows and columns), except for a column "Reviews" with fluctuating values.

I want to show a stacked bar chart that shows how many reviews each person did per month, for all months. I was able to connect all three tables based on the person's name (inner join), and I created a measure that summed the reviews in all three tables. But that shows me the total and I want to see a monthly breakdown in a stacked bar chart. I thought about combining all the data into an 'Overall' table, but then I lose the monthly breakdown component. Can someone suggest how to solve? Thanks in advance!

[Ashish_Mathur]

Hi,

You should be appending all tables (not joining them).

[parry2k]

@Anonymous I think combining the table makes sense, add person column on the x-axis, month on legend and value on values and you should able to get the result, instead of creating 3 measure, you just need to create one.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡