Forum Discussion
Intersection between two Table visuals created in dashboard
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
Hi TomMartens ,
Thanks for the solution. But I want to find intersection between table visuals in dashboard(Table 1 and Table 2 in my case). Please find my dasboard on this link: https://drive.google.com/file/d/1VccYRCnyK_-rUleBwLuP6f1ildCg93Vr/view?usp=share_link
Let me know If you need anything else.
Thanks is advance😀