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