Magic Music Visuals

hey i was under the impression that i could create a clear overlay .png in photoshop and then use this to create a visualization that would be transparent so i could put it over a video in my editing program but when i tried the background came out solid is there something im doing wrong??? Thanks