For this clusters demonstration, we are going to use the SQL Data Source that we created in Connect to SQL Server article.
Create Power BI Clusters
Please click on the … (3 dots) on the top right corner of the chart to see the Clusters option. As you can see from the below screenshot, we selected the Automatically find Clusters option from the menu.
Clicking the Automatically find Clusters option will open the following Clusters window
- Name: Use this text box to rename the default generated clustered name
- Field: Field or Column that you used for Clustering
- Description: Write a meaningful description that describes this cluster
- Number of Clusters: By default, Auto is selected. However, you can specify any integer value
For this demo, we are leaving all the default values. So, let me click OK button
An auto option has generated three clusters
Edit Power BI Clusters
You can edit the cluster in two ways. Under the Visualization tab, click the down arrow beside the Cluster, and select the Edit Cluster option from the menu.
Or, please select the Cluster that you want to edit, and right-click on it will open the context menu. Please select the Edit clusters option from it
Clicking the Edit clusters option will open the following window. Use this window to change as per your requirement
Let me change the default three to six
Now you can see, it has generated six different clusters
Delete Power BI Clusters
Please select the Cluster that you want to delete. Next, right-click on it and select Delete option from the context menu.
Create Manual Power BI Clusters
This is the same as the first example but this time we are changing the Number of Clusters value from Auto to 5.
and you can see the 5 clusters
Let me use this cluster on another (different) report. For this, we created a Bar Chart using Postal Code Cluster (newly created) and Sales Amount
Like normal columns, you can also Filter Clusters