Checkbox filter does not work while searching results with multiple option selected

Hi,
Just found out the Check box filter actually works on “AND” and not by "OR"ing inclusions. so if you have say 5 options as part of your check box, and a listing has 2 of them checked, to be able to see that listing while searching, user must select those exact two options or one of them otherwise that listing wouldn’t come up in the search.

Instead when user selects multiple options from the checkbox filter, that usually means they want to see all listing which have either of the selected or all of them matching in available listings. So even if they have selected an option which is not checked in the listing but the rest of them are then that listing should still come up in search.

This will impact a big time having the checkbox as filter. On the other hand the dropdown filter works just fine and above scenarios would work best having Dropdown filters. But the limitation here would be while posting a new ad, having a field as dropdown would only allow advertiser to pick just one option and not multiple.

so as an example as a bicycle seller i would like to have a Colour checkbox and select how many ever colours i have in stock so when a user searches for either of those colours along with others which i dont have, my listing should still appear. however, unless users select all or a few of the colours which i had selected while posting my ad, my listing would not come up.

hope it makes sense!
Would appreciate some help or clarification if I am using the filters wrong.