I am extremely bad at playing football but extremely good at playing foosball.
So what would be the appropriate phrase or idiom for such a scenario?
My football and foosball skills are chalk and cheese..
We have hundreds of phrases to indicate the similarity of one thing with another and similes like 'as alike as two peas in a pod' are commonplace in everyday speech. There are far fewer expressions that explicitly refer to the difference between things; 'as different as chalk and cheese' is the most commonly used. This is an old expression and the earliest citation is in John Gower's Middle English text Confessio Amantis, 1390: Lo, how they feignen chalk for chese.