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 - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
