My Favorite Fantasy

The single debuted at No. 88 on the Billboard Hot Soul Singles chart for the week ending April 29, 1978.[10] From May 20 to June 3 (week 6) it stayed at the peak position of #76.[11][12][13] Also on that week, his composition, "Don't Pity Me" by Faith Hope & Charity had made its debut at #85.[14] "My Favorite Fantasy" spent a total of eight weeks in the chart.[15][16]

The song made its debut on the Cash Box Top 100 R&B chart on the week ending April 22, 1978.[17] Being noted as one of the R&B Playlist Highlights, it was also seeing a fair amount of radio play action for that week. It was getting spins on Paul Childs' show at WIGO in Atlanta, Don Brooks's show at WWIN in Balitimore, E. Rodney Jones' show at WVON in Chicago, Mike Payne's show at WABQ in Cleveland and several others.[18] It was also noted as the third most added r&b single at WESL, WABQ, KPRS, WJLB and WYLD for that week.

At week 10, on June 24, the song peaked at #51.[19][20] Also on the same chart that week, "Don't Pity Me" by Faith Hope & Charity was at 46.[21]

The single made its debut on the Record World R&B Singles Chart at #67 on April 29, 1978.[22] It peaked at #48 on week 8 on June 17.[23][24]

By the week of May 27, the single was seeing some airplay in Canada. It was getting spins on the Pierre Borque show at CHRC in Quebec City.[25] It also charted in Canada. On the week of June 10, it was making its debut at #50 on the RPM Adult Oriented Playlist.[26] On the week of June 24 the A side was getting spins on David Collins Carter's show at CKBW in Bridgewater while the B side "You're So Right For Me" was getting spun on Guy Bonnier's show at CHCL in Medley.[27][28] It was now in its third week and had moved up to #42 on the RPM Adult Oriented Playlist chart.[29] It peaked at #37 on the week of July 15 which was its sixth and final week in the chart.[30][31]

On the week of July 1, the record was getting air play on BRMB Radio.[32] On the week of July 08, the record was one of the five records in the Radio One Record of the Week section, and a pick on Tony Blackburn's show. It was also a hit pick by Steve Hamilton on Radio Forth.[33][34] By July 15, the record was getting played on Radio Tees.[35]

On the week of July 29, the 12" version issue of the record made its debut in the Record Mirror UK Disco Top 90 chart.[36] Peaking at #70 on August 5,[37] it spent a total of three weeks in the chart.[38] It was still being played on the Radio City Playlist for the final week.[39]