Forum Discussion

ashmeet50's avatar
ashmeet50
Frequent Visitor
8 years ago
Solved

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 t...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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's avatar
    v-yulgu-msft
    8 years ago

    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's avatar
Andre_Maciel
Frequent Visitor
8 years ago

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's avatar
ashmeet50
Frequent Visitor
8 years ago

For eg. I have 2 data sets such as

Reference numberAge
xyz12323
ery 24556
asd4545667
vsvc565634
gsfxgvd4545678
asdas34
dsad56
fghfh568

 

and

 

Reference numberAge
ffe533
edf545
eeq5454
qeqe234
ew768
asasas567
e789
sasewd433

 

And the way I am doing right now is