Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to see Cluster Values option

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?

 

 

 

Need Help

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    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's avatar
      edhans
      Community Champion
      5 years ago

      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's avatar
        edhans
        Community Champion
        5 years ago

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