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
Table 2 visual
Expected output Visual
Hey @Bikashjha ,
it's difficult to provide any solution or even guidance. As the information you provided is too scarce.
What is needed:
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.
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:
This means the model of the dataset has to be adjusted. I will think about a solution in the next couple of days.
Thanks @TomMartens for the effort!
please let me know if I can solve this business problem through any other way in power bi
Hi @Bikashjha ,
You can use INTERSECT DAX function to find the intersection between two tables.
Syntax :- INTERSECT(<table_expression1>, <table_expression2>)
Please refer to this link :-
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.