In case of the effect of a spell, just change the attachment point to "overhead".
If is a triggered spell, then just use the function to create a special effect to a unit and set the attachment point to "overhead".
If it doesn't work, probably there is something wrong with the model of the unit you wanna attach to the effect.