- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks a lot for your answer, but I would like to do it without creating measures.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 💡
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI knows it is 2 separate things which does not mean that a custom Visual could not handle them as one table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 💡
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-21-2023 06:06 AM | |||
07-15-2024 05:17 AM | |||
01-03-2024 12:28 PM | |||
01-31-2024 04:08 AM | |||
09-18-2024 10:15 AM |