Unable to see Cluster Values option

[Anonymous]

Hi all,

I'm trying to use the cluster values functionality in Power BI desktop, but I can't see the option for this? I've tried following the steps here https://docs.microsoft.com/en-us/power-query/cluster-values , but I must be missing something. I've put a screenshot of what I see below.

Could anyone advise what I'm missing here?

[edhans]

The Cluster of Values button only exists in the Power Query online tool, like when creating a data flow or a SQL query using Power Automate. It isn't in the desktop. That page you linked to doesn't make that clear at all.

You can do this manually in the Advanced Editor of Power Query. Use the Table.AddFuzzyClusterColumn function. You'll have to know how to add a new step and enter all of the parameters manually for now until this feature makes its way to the desktop via a button.

[edhans]

FYI @Anonymous the article has been updated to reflect this is a Power Query online feature. Again, you can do it manually with the formula listed above.

[edhans]

@Anonymous did this answer your question? If so, can you mark one of these as the solution? thanks.