Clustering values
Data often comes from original data sources in many forms and you can end up having multiple variations of the same value where you need to have a unique value. In this case, you need a way to group and correct these values quickly, without creating complex rules or doing it manually. In this recipe, we will see how to leverage the clustering values feature, which enables you to automatically group data based on similarities thanks to an underlying algorithm.
Getting ready
For this recipe, you need to have access to the Power BI portal, for which a Power BI Pro license is needed. You also need to have access to a workspace.
How to do itβ¦
After you log in to the Power BI portal, perform the following steps:
- Browse to your workspace, click on New, and click on Dataflow.
- Click on Add new tables in order to connect to a data source and access the Power Query online UI.