It's used when a problem is exaggerated.
Example:
"The bomb threat turned out to be a storm in a tea cup" could be used if a building was evacuated for a bomb threat that turned out to be a prank.
You sometimes see it used in news headlines.
My personal favourite: "The dog's bollocks".
Hope I don't get told off for that one.