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
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?
Is there anyone else on this list who could send me a data set that works, so I could test it on my machine?
Also, this issue is not necessarily isolated to me, but I seem to be the first person to report it?
Until then, could someone change the status of this issue to "Unsolved"?
Thank you!
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"
Does anyone else have an answer?
What version of Power BI is everyone else using?
Could someone change the status of this question to "Unsolved/Not solved", until a solution to the problem is found?
Thanks!
Did you check your version of PBI from the desktop app itself (under File > Options and Settings > Options > Diagnostics)?
Have you read/watched this: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#analytics
Also, be aware that the auto clustering is pretty limited in that if you don't have the correct data and data formats then it wont be available as an option.
If you can and want to share your data (dummy data is okay) or pbix file, I can take a look at it and see why it may not be working.
Last, since this seems to be an isolated issue for you, I would open a support ticket.
1) Yes I did: "File > Options and Settings > Options > Diagnostics"
2) Yes I watched the video.
3) Could you send me data that works instead?
4) How do I open a ticket?
Hi
I had this issue on the most recent build of Power BI Desktop, 2.65.5313.841 64-bit (December 2018).
As mentioned by a previous poster, this feature is no longer on preview so you don't need to turn on anything specifically.
My issue was because I converted an existing visual to a scatter chart and then tried to apply automatic clustering.
I fixed this by doing the following:
1. Remove the visual
2. Add a new Scatter Chart
3. Set the details, x-axis and y-axis as required.
4. Viola! The "Automatically find clusters" item is available in the "..." menu
5. Click this item and the clustering is applied as expected.
Hope this helps.
Ashley