OK I have been through hell over the years trying to find a comfy bra that actually has support.
I never really found one until I fell pregnant and started using maternaty bras, they are sooo unbelievably comfy, and they have great support.
That is what worked for me, but as others have meantioned you may need to go on a bra hunt through all the store until you fine the perfect one