Damp squib

 Damp squib-A situation or event which is much less impressive than expected.

Example.The party was a bit of a damp squib in the end.