How to color markets on a geomap based on a column with too many categories to threshold

My data has a Lat and Lon column and column I’ll call Site. I want to color every market based on its site so i can see clusters based on site/color.

My site column has potentially endless possible values so I can’t color them by threshold.

I’ve tried selecting the color scheme to either color palette and color palette(by series name) and selecting my column under the marker color dropdown but all my colors just stay the same. I’ve converted the sites to strings and confirmed there’s multiples of each site, not just one.

Any suggestions please?

welcome to forum @lels160

what is your datasource?

Thanks for the reply, its ADX azure data explorer.