I think this phrase means to be very fashionable or popular.
For example if we are arguing about what smartphones are better and you are telling me that Samsungare really good phones, i'll probably respond that: Iphone's are where it's at. Meaning that i consider that Iphone's are more popular.