Clustering with categorical data

[smacsween]

Hi

I am trying to use clusters using various different 3rd party visualisations.  They need me to have the data in numerical format but a lot of my data is categorical (country, department, etc).  

In  Python I would do a Transform or Encoding (eg OneHotEncode) to transform the categorical into numerical, but how do I do this in PowerBI?

Thanks

Scott

[smacsween]

Thanks Pat, yes it's the ones from the marketplace.  I will give that a try with Python and with query editor, I appreciate your advice.

[mahoneypat]

Sounds like you have looked at the visuals in the marketplace, but fyi if not.  FYI that, if you do know Python, you can use the Python visual to create your own visual.  To do it in the query editor, it would be helpful to see example data and desired output; however, I would probably approach that by making a distinct list of the categories and then add a custom column where it find the position of that category in the list for each row.  You also could do a RANKX on that column on the DAX side to get a number based on alphabetical order.

Regards,

Pat