Need some help with a comparison of two table visuals. One table (table A) has vehicles received and the other table (table B) has a list of vehicles that had a certain accessory installed. Both contain a similar field called VIN.
I need to know which VINs from Table A are not in Table B. Attempts to use "does not contain for the accessory code" fails with resource errors. I do this all the time in Microsoft Access but have not in Power BI so would like to know how. Thanks for any assistance.
Table screen shots are below.
Hi mike.
See this example Table1 and table2. BB is missing in table 2
1- Make the relationships of the model
2 - make a table visual and in FILTERs select TABLE2 advanced filter IS BLANK.
See pictures below
Hi mike.
See this example Table1 and table2. BB is missing in table 2
1- Make the relationships of the model
2 - make a table visual and in FILTERs select TABLE2 advanced filter IS BLANK.
See pictures below
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
