Forum Discussion
Clustering
Hi gwp,
Yes, to use Automatically find clusters feature, we shouldn't place any field in Legend property. As after we click Automatically find clusters button and the clustering algorithm runs, it will create a new categorical field with the different cluster groups in it. This new field will be adding to the scatter chart's legend property automatically to class bubbles.
Best Regards,
Qiuyun Yu
That means you no longer need to enable it in the preview features menu. Once you correctly set up a scatter plot, click on the elipses ("...") and you should see the option:
What do you mean by "Once you correctly set up a scatter plot", I think I have done that?
All I get are the "Export data", and "Remove" options, I do not get the 3rd option, "Automatically find clusters", what can I do differently to get that 3rd menu option?
Can you take a screen shot of the scatter plot and the fields pane that shows what you've put for the axis, values, etc? Also, what are the data types of your axis?
X Axis = C = numeric(10,1)
Y Axis = P = numeric(10,1)
Details = Name = varchar(50)
Data types as given in SQL Server, not sure what they are in Power BI?
All other options are emtpy, except 'Visual level filters', which auto-fills?
Go to the fields pane (or query editor) in the desktop app and click on the fields you are using for the axes. Then click on the Modeling tab and check the data type. Make sure they are numeric.
I'm using demo data (Contoso DB) and I have two numeric fields as the axes; one is a dollar amount and one is a whole number, and Product name is the Details. I have the option to Automatically Find Clusters.
One last thing to check is which version of PBI are you using?
you have to left Legen field balnk and no drill down in the Detail field (I mean left the Detail field only one item after u auto clustering u can add more item in this field).
