Forum Discussion
Merging two column charts together
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
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
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
5 Replies
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.
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
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
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
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
