Forum Discussion

Bikashjha's avatar
Bikashjha
Frequent Visitor
3 years ago

Intersection between two Table visuals created in dashboard

I have created two table visuals on dashboard consists of one columns from main data source(present in Field). How can I find intersection between them.   Table 1 visual Custid  1 2 3   Table...
Need Help
Tutorial Requests
TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Bikashjha ,

 

it's difficult to provide any solution or even guidance. As the information you provided is too scarce.

 

What is needed:

  • are the two table visuals fed by the same table of the Power BI dataset
  • what filters are active that influence the result of both table visuals

Nevertheless, you can consider creating a table that reflects on the intersection of "two tables" (assumption due to the scarce information) using the Merge transformation inside Power Query: Merge queries overview - Power Query | Microsoft Learn

 

The next images show how this can be achieved:

 

 

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom