You would first enable the type of controller support in Steam Big Picture settings. Then plug in the controller before launching the game. If you start the game before plugging in the controller, it may not work. You do not need to start the game from Big Picture mode.