How to set up expanding material with custom panning and tiling?

I am not very sure but I think you need to change the “X/Y-axis Tiling Method” to a Clamp instead Wrap inside the texture editor (in your case, the normal map texture).