The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 ?
Thanks a lot for your answer, but I would like to do it without creating measures.
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! | |
Power BI knows it is 2 separate things which does not mean that a custom Visual could not handle them as one table.
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! | |
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |