In this section, we show you how to create Power BI clusters with an example. To explain this concept of Clusters, we will use the scatter plot that we created earlier.
For this Power BI clustering demo, we will use the SQL data source that we created in the Connect to SQL Server article and the scatter chart.
Create Power BI clusters
Click on the … (3 points) in the upper right corner of the graph to see the Clusters option. As you can see in the Power BI screenshot below, we select the Find clusters automatically menu option.
By clicking on the Find clusters automatically opens the following Clusters window
- Name: Use this text box to change the name of the default generated cluster
- Countryside: Field or column that you used for clustering
- Description: Write a meaningful description that describes this group.
- Number of clusters: By default, Auto is selected. However, you can specify any integer value
For this Power BI cluster demo, we left all the defaults. So let me click the OK button
An automatic option has generated three groups
Edit Power BI clusters
You can edit the cluster in two ways. On the Display tab, click the down arrow next to Cluster and select the Edit Cluster option from the menu.
Or, select the Cluster you want to edit and right-click on it to open the context menu. Please select the Edit bunches choice of her
By clicking on the Edit clusters The option opens the following window. Use this window to change according to your needs.
Let me change the default from three to six
Now you can see, you have generated six different clusters.
Remove clusters from Power BI
Select the cluster you want to remove. Then right click on it and select Remove context menu option.
Create manual Power BI clusters
It is the same as in the first example, but this time we are changing the Number of clusters value of Car to 5.
and you can see the 5 groups
Let me use this group in another (different) report. For this we create a bar chart using the postal code group (just created) and the sales amount
Like normal columns, you can also filter clusters