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😀
Hey Bikashjha ,
I can tell you that this will not work, the reason is:
- a table can not be generated from an existing table initiated by slicer selection
This means the model of the dataset has to be adjusted. I will think about a solution in the next couple of days.
Regards,
Tom
Thanks TomMartens for the effort!
please let me know if I can solve this business problem through any other way in power bi
Thanks,
Bikash
