Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Combining 2 tables with the same columns into a Matrix visual

Hi there

 

I have two tables with the same set of columns but for some reason I don't want to make a UNION in DAX or to combine them in Power Query. Is there a custom Matrix/Table Visual who allows to see the two tables as if there were only one ?
I guess it is impossible, but who knows ?

Need Help

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello Anonymous ,

     

    If you have dimension tables that are both linked into the two tables, then you can show the results of the two tables with the dimensions in a matrix where you can sum the values in measures and show them.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote for my Community Mobile App Idea 💡

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks a lot for your answer, but I would like to do it without creating measures.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Power BI knows it is 2 separate things which does not mean that a custom Visual could not handle them as one table.