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
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?
The Version of Power BI I am using is: 2.45.4704.442 64-bit (April 2017)
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/
Not sure what that means?
My x and y axis fields are both "Data type: Decimal Number"