Merging two column charts together

[ashmeet50]

Hello Everyone,

I have made 2 column charts and both of them have different data sources.

Age groups and Reference numbers are different in both the cases.

How can I merge these two graphs where the values on the x axis remain the same and I can see the data like this picture 

[v-yulgu-msft · Accepted solution]

Hi @ashmeet50,

New a calculated table:

TB3 =
UNION (
    ADDCOLUMNS ( TB1, "Legend", "Source1" ),
    ADDCOLUMNS ( TB2, "Legend", "Source2" )
)

Then, create group bins based on [Age] in "TB3".

Best regards,

Yuliana Gu

[v-yulgu-msft · Accepted solution]

Hi @ashmeet50,

New a calculated table:

TB3 =
UNION (
    ADDCOLUMNS ( TB1, "Legend", "Source1" ),
    ADDCOLUMNS ( TB2, "Legend", "Source2" )
)

Then, create group bins based on [Age] in "TB3".

Best regards,

Yuliana Gu

[ashmeet50]

Hello Yuliana,

I am getting an error message

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Ashmeet Singh

[v-yulgu-msft · Accepted solution]

Hi @ashmeet50,

Above error is caused by typing the DAX formula into a measure.

What you need is a calculated table as highlighted in below screenshot.

Best regards,

Yuliana Gu

[Andre_Maciel]

You need to create a relationship between this two tables, what is your key field? Maybe you will need to create a auxiliar table, with a distinct list of this key value and then connect this two tables to a new auxiliar table.

Show some example of this data, it will help us to demonstrate.

[ashmeet50]

For eg. I have 2 data sets such as

Reference number	Age
xyz123	23
ery 245	56
asd45456	67
vsvc5656	34
gsfxgvd4545	678
asdas	34
dsad	56
fghfh	568

and

Reference number	Age
ffe	533
edf	545
eeq	5454
qeqe	234
ew	768
asasas	567
e	789
sasewd	433

And the way I am doing right now is