Morning. I’m glad that you found a solution.
If you want more detail on how sorting work in VFX Graph, both Per-particle sorting, Output Sorting or Sorting between VFX instance I would recommend that you take a look at those two posts:
You seem to have different VFX instances, so the position of your VFX should definitely influence the sorting of your VFX instance. Now, how you can see in the post mentioned above, the Bounding Box of your VFX is what’s considered.
I hope that it will help you and that you’ll be able to reach your goal.
Have a lovely day.