Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Clustering with categorical data


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?




Frequent Visitor

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.

Super User IV
Super User IV

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.







Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors