"I tried the magnet/needle/compass thingy, never could get it to work... mine always ended up on the bottom of the container."

You left out one tiny step: Wax the needle. That's what makes it float.

And be sure you only run the magnet in one direction on the needle, not back and forth.

Sue