BAQ: When bin is at zero show next bin with inventory


I’m very new to BAQ’s/Dashboards, but have recently had some minor success. I’m stuck on the best way to solve my current requirement. I am creating a BAQ/Dashboard to be able to pull a pick list for jobs by BIN. We have multiple bins for each part. I would like a way to show only 1 bin with inventory and only show the next bin if the first bin doesn’t have enough to fulfill the requirement. Any ideas the best way to go about this?

Appreciate any help I can get!