Want to color code points that CLUSTER in a Scatter visual

[bvy]

Very simple data set -- Category and (X, Y) coordinates plotted on a Scatter. I want to color code points that cluster. The only way I can think to do this is to count the number of nearby points (by radius of 5 units, for example) -- if a point has 0 neighbors, it gets one color; 1-3 nieghbors, it gets a different color, etc. It should be subject to the filter selection of course (Category in this case). Is there a measure or some other clever way to accomplish this? Looking for ideas. Thank you. 

[v-xuding-msft · Accepted solution]

Hi @bvy ,

If you want to implement it in a Scatter visual, you could watch this: Cluster Analysis Visualization Techniques For Power BI - Power BI Review  to have a try.

If you could use custom visual, @mahoneypat  is right, the visual of Clustering is a good choice. You could reference the blog and video to learn more about it.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#clustering

https://www.youtube.com/watch?v=NjdZjozKboA

[mahoneypat]

Please check out the marketplace visuals in AppSource (free).  Click the ellipsis in the Visuals area and choose "Get More Visuals".  Search for Cluster when there to see these options.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[pranit828]

HI @bvy 

Use the legend section to color code.

[bvy]

@pranit828 How does that apply to points that cluster?