Charts with multiple tables

[Clueless]

Dear All

I have 2 tables which I want to create a stacked bar for comparision.

TABLE#1

Amount - Quarter

1K - Q1

2K - Q1

3K - Q2

TABLE#2

Amount - Quarter

1K - Q1

2K - Q1

2K - Q2

3K - Q3

4K - Q4

What I want bisically is a smple bar char like the one below but unfortuanlly I encountered several issues

 https://drive.google.com/file/d/1BiB0r-8XG1bg4OhQmu8epJNy_92T47lv/view?usp=sharing

first issue, I couldn't create a chart bar I read online that I have to create a relationship between the tables so I did by inserting a new column as row ID in both tables.. I did that in the datasets itels (excel file) if there is better way please help me.

Then I was able to create a chart, but ONLY the first table has the correct sums in the Qs, the second one is WRONG.

If I select the table1 first then its sums are correct and table2 wrong, and if I select table2 first then its sums are correct and table2 is wrong

it's driving me crazy!

[MFelix · Accepted solution]

Hi @Clueless,

First of all believe that your information is pretty short and this is not the full data and needs for you, but based on the information follow this steps:

• Create a table Quarters
  • Q1
  • Q2
  • Q3
  • Q4
• Make a relationship between this table and the other two based on the quartes column
• Add the Quarters table column as axis and the values of tabel 1 and table 2 as values on a column chart

See attach PBIX file.

Regards,

MFelix

[Clueless]

Thanks it worked!

Indeed the dataset is much bigger bur for this chart I only needed 2 columns.