Fancy Moves strengthens guns and knives used inside melee combos once you have done it 75 times. Tool Combo is the skill that makes it possible.
Fancy Moves unlocks after this challenge: use a gun or knife in a combo 75 times. As with the other 28 base perks, the Fancy Moves challenge also counts when you play Lydia in the World War I simulation.