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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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

ashmeet50's avatar
ashmeet50
Frequent Visitor
8 years ago

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's avatar
    v-yulgu-msft
    Microsoft Employee
    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