Merge two or more tables visuals into new one

[Gianluca88]

Hi,

I can hardly understand how to merge two table visuals to obtain only one. 

I will try to better explain: suppose that from table visual A we have the table "myTable" in which 3 records are shown. In the visual B we have another table (or a copy of table "myTable") that is "myTable2", that turns out to have the same column set of "myTable", and 2 records are shown. 

Is there room for creating a new table visual with the same column header and with the (3+2) records?  

Thanks,

Gianluca

[Gianluca88]

Hi @amitchandak 

many thanks for your prompt response. 

https://we.tl/t-Fusd0mMcW4

I attached a simple version of what I mean. 

Many thanks,

Gianluca

[lbendlin]

You would need to use disconnected tables and measure based visual filters for that.  Lots of effort - are you sure you really need that?

[Gianluca88]

Hi,

thanks for your prompt message. Yes, because I want to give a more suitable visual to my customer in several reports. Could you help me implemeting it in the example pbx I previously shared?

I noted, moreover, that the concept of disconnected tables is strictly related to the use of a slicer, like in my sample example. What happens if I want to use the data selected via drill-through operations rather than manually selected with a slicer?

Sorry, I m quite new using Power Bi so, sorry in advance if I m not so clear in the explainations. 

Many thanks,

Gianluca

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.

[Gianluca88]

Here you can find a simple but complete example

https://we.tl/t-gKXX04A7xx

Many thanks and sorry for my not clear explainations,

Gianluca

[lbendlin]

I assume you are aware that Power BI automatically groups rows in table and matrix visuals. If you plan to merge visual A with visual B you will be unable to tell where each row came from. Is that acceptable?

[Gianluca88]

I am quite new to use this tool, so I also accept as solution the fact that my request is not feasible at all.

Let me know,

Many thanks,

Gianluca

[lbendlin]

I would not call it infeasible just yet but it certainly is highly unusual, what with the data model being upsidedown etc. Maybe some more business context would help.

[Gianluca88]

At the moment I am involved in learning and making practice with Power BI. The question is not only aimed at satisfying my customer, but also at exploiring in-depth the logics of Power BI, with the use of DAX formula and some pretty complex tasks. The business problem is more or less what I shared with you in the last link, I mean there is a share table (Node, of which I produce a copy as a workaround) and two different tables (NodeSelectorA and NodeSelectorB) can access at the same table and i just want to display the complete list of records of the table Node selected, with hopefully a flag column which highlights whether the Node record selected comes from NodeSelectorA or NodeSelectorB. Obviously, I can do this job with a view on Oracle (where my data come from) and ,there, using "union" sql command. But I would like to know whether there is room for this type of action also in Power Bi. 

Thanks,

g.

[lbendlin]

No, you can't do this job in Oracle because then you cannot have users interacting with the slicers.

Power BI in general likes to work with data models that are star or snowflake shaped, with "dimension"  tables pointing towards "fact"  tables in a 1-to-many relationship with (ideally) single search direction. 

There is a fundamental difference between immutable elements (like calculated columns and calculated tables)  and mutable elements (measures).  Currently measures have to return single scalar values.  So what you are trying to achieve (a dynamic table)  is not something that is currently supported in Power BI.  There are some tricks you can apply (measures as table filters) but they are only workarounds, not solutions.

[Gianluca88]

Yes, the idea is to have only one visual. In SQL, I can simply do that by union of two queries with a bind variable for example. Eventually, I ll be able to tell where each row will come from because i can use an additional field in the two merged queries.

I hope I m clear.

Thanks again,

Gianluca

[amitchandak]

@Gianluca88 , Assume I have Table1 and Table2 with common columns. Then I need to create common dimension and show them together

refer: https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.