Skip to main content

Power BI

Completed

Clustering

Vote (46) Share
Paul's profile image

Paul on 11 Aug 2016 20:01:46

I would like to see the ability to group a particular set of objects based on their characteristics, aggregating them according to their similarities.

Administrator on 29 Nov 2016 06:36:10

We just released a preview of clustering in the latest release of Power BI Desktop. To learn more, check out this blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/

Comments (5)
Paul's profile image Profile Picture

a0c3aa9a 00ae-4932-87e7-083ec59d6d86 on 05 Jul 2020 22:37:22

RE: Clustering

Clustering does not appear to be working

Paul's profile image Profile Picture

7ccb1962 3a7a-4e6f-8e3b-7c1248bab8fc on 05 Jul 2020 22:35:32

RE: Clustering

This issue should not be closed as completed. Clustering does not appear to work with SSAS data sources (either Tabular or OLAP). Grouping data and Binning data also do not work with SSAS. Is there a solution or can you reopen this as not yet completed?

Paul's profile image Profile Picture

a0154be3 1c0f-4d49-9294-0c2be0711500 on 05 Jul 2020 22:33:14

RE: Clustering

DOes that mean K-Means Clustering and Voronoi type tools will become available ?

Paul's profile image Profile Picture

5dc3e78d 80d0-4ff8-b584-1856d97d9cd7 on 05 Jul 2020 22:29:51

RE: Clustering

like this idea, but out of votes

Paul's profile image Profile Picture

587423a6 0263-44d8-8d7f-a9a5326d0017 on 05 Jul 2020 22:29:51

RE: Clustering

Tableau 10 recently added built-in k-means clustering, and it is really well done. I would love to see something comparable in Power BI.

From the Analytics pane, you can drag Cluster into your visual to create the clusters. You have the ability to keep all continuous fields or select a subset. You can keep the automatic value of k, or you can manually select k. Once the clusters exist, you can get a description of what is included in each cluster and an analysis of variance.

Automatic selection: http://i.imgur.com/rUnYF0g.png
Manual feature and k selection: http://i.imgur.com/SPgUWMr.png
Describe clusters: http://i.imgur.com/9fahPXF.png