Skip to main content
SimilarExport ZIP
100%

KMeans clustering call in DAX Power BI desktop 3D

✓ Published0🌍 Public
HHugoberry
Last edited Jun 27, 2017
Created on Jun 27, 2017

This example demonstrates a 3D KMeans clustering visualization built directly in DAX for Power BI, using the Iris dataset’s numeric columns (Column6, Column7, Column8). It shows how raw table columns are summarized and then passed into the custom `KMeansClustering` DAX function, which assigns each data point to a cluster and returns a cluster ID alongside the original attributes. The code explicitly constructs a DAX query with `SUMMARIZECOLUMNS` and `SELECTCOLUMNS` to shape the data, then calls `KMeansClustering` with parameter lists defining attribute roles and output columns. The rendering approach is not visible here, but the focus is on the algorithmic clustering step within Power BI’s DAX engine.

AI-generated description

Similar vizzes

Loading thumbnail…

K-means clustering in DAX

This example demonstrates a K-means clustering implementation written in DAX, showing how to group items into clusters based on multiple numeric attributes. The code computes a transformed table using `SUMMARIZECOLUMNS` to aggregate attribute values per item, then passes that table to a custom `KMeansClustering` function. The function assigns each item a `ClusterId` while preserving the original item labels. The visualization highlights the resulting clusters, with the DAX code serving as the core analytical engine rather than relying on a JavaScript library. The source is a gist by Hugoberry, and the rendering approach is not visible here, so the focus remains on the clustering logic and the data transformation pipeline.

HHugoberry
82% match
Loading thumbnail…

Gist 599b117350a329c9046f68ae0ce1e21a

This example visualizes a k-means clustering result over a set of data points, showing how the algorithm partitions the space into distinct clusters based on two measured attributes. The chart is generated from a Power BI DAX query that first summarizes the source table `Query1` by summing the X and Y values for each category Z, then feeds those aggregated coordinates into the `KMeansClustering` function. The output assigns a `ClusterId` to each point, which the visualization likely encodes through color or position. The rendering relies on Power BI’s built-in visual engine rather than a custom JavaScript library, as no D3 or Canvas code appears in the provided DAX.

HHugoberry
81% match
Loading thumbnail…

A worked example of using the undocumented DAX function KMeansClustering

This example demonstrates how to cluster a set of labeled numeric values using the undocumented DAX function `KMeansClustering`, which partitions the sample data into groups based on their attribute values. The visualization shows the resulting cluster assignments for each item, with the function called directly in a DAX query. The code supplies a table of letter-value pairs, specifies the column mappings for the attribute and item labels, and requests cluster IDs as output. The clustering runs with a parameter of -1, indicating automatic determination of the number of clusters, and the result appears as a table of items paired with their assigned cluster identifiers.

HHugoberry
77% match
Loading thumbnail…

R flavoured Kmeans algorithm in Power Query

This example demonstrates the R-flavored K-means clustering algorithm executed directly within Power Query, using the iris dataset’s petal width and length columns to assign cluster memberships. The visualization shows the resulting iris data points colored by their assigned cluster, with the clustering computed in R via the `kmeans` function and seeded for reproducibility. The Power Query M code invokes the R engine through the `R.Execute` API, passing a script that runs K-means with three centers and twenty random starts, then returns the augmented table containing the cluster labels. The underlying data originates from the built-in iris dataset, and the rendering relies on Power Query’s native table output, not a separate charting library.

HHugoberry
76% match
Loading thumbnail…

Exploring displaying microcharts and sparklines in table/matrix visual in PowerBI

This example demonstrates how to embed a wide range of microcharts and sparklines directly into Power BI table and matrix visuals using a single DAX measure. The measure returns a text string composed of Unicode block characters, which the visual renders as the final chart. The code includes a calculation table with pattern definitions for bar charts, bullet charts, win/loss charts, dot plots, candlestick charts, and horizontal comparison bars, each using characters like blocks, circles, and lines. The approach requires no external libraries, relying solely on DAX string manipulation and the native Unicode font rendering in the Power BI visual.

HHugoberry
66% match
Loading thumbnail…

K means clustering

This example shows the k-means clustering algorithm in action, animating the iterative process of grouping a small set of points from `data.csv` into three clusters. Initially, three randomly placed centroids are drawn, and each iteration assigns points to the nearest centroid using Euclidean distance, then moves the centroids to the cluster mean. The visualization uses D3 v6’s selection and `transition` methods to animate the points and centroids, with the centroid styled distinctly via a black stroke. The iteration count is displayed as text, and the animation stops after ten iterations.

Kkaviya-ds
65% match
Loading thumbnail…

KMeans clustering

This example demonstrates KMeans clustering on a small dataset of six points loaded from a CSV file. It shows how points are iteratively assigned to one of three clusters, with colored hulls drawn around each group and centroids recalculated until a local minimum cost is reached. The visualization uses D3.js v4 with a React framework, rendering SVG circles and polygon hulls with animated transitions. The code employs `d3.csv`, `d3.polygonHull`, `d3.scaleLinear`, and `d3.interval` to animate the clustering process, displaying the iteration count in the final state.

NNaveenaS12
64% match
Loading thumbnail…

Power BI desktop tabular mining model

This example demonstrates a Power BI Desktop tabular mining model, exposing the structure of Data Mining Extensions (DMX) schema queries used to retrieve model metadata. The visualization shows how the model defines expressions, variations, sets, and extended properties, with the underlying code failing to access the referenced mining model due to permission errors. The implementation relies on Power BI’s tabular engine and DAX, while directly embedding DMX queries like `select* from $tmschema_expressions` to inspect the model’s internal schema. The rendering approach is native to Power BI’s table visual, displaying the raw query results and error states without external libraries such as D3 or Three.js, focusing instead on the interaction between DAX and the mining model’s metadata layer.

HHugoberry
62% match