I’m confused by your post. You say you are using 1/4” mixer out into XLR speaker in, but the cable you linked is RCA which is not the same as XLR.

This cable is 1/4” to XLR male. You also want to check the gender of the line in on your speaker, make sure it wants male. Link: TISINO 1/4 to XLR Cable, Nylon Braid Quarter inch TRS to XLR Male Balanced Interconnect Cord Patch Cable- 3.3ft https://www.amazon.com/dp/B083R4CDT2/ref=cm_sw_r_cp_api_glt_i_RJJP4E45ZJ1QW4M53NGC?_encoding=UTF8&psc=1