Graphite is what I've used.

If you read the internet many also say white lithium type grease works too.

What you don't want is any sort of oil. When it gets cold the oil viscosity will change enough to make the cable hang up and cause the needle to fluctuate. It goes away when the car gets warmed up, but still annoying.