Combining 2 tables with the same columns into a Matrix visual

[philthegaps]

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 ?

[philthegaps]

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

[Idrissshatila]

@philthegaps ,

So it should be done through Power Query, Calculated Column, or Dax. There is no other solution because Power BI will recognise it as two seperate columns.

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 💡

[philthegaps]

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

[Idrissshatila]

Hello @philthegaps ,

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 💡