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

Clustering with categorical data

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

2 REPLIES 2
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.

 

mahoneypat_0-1606054555733.png

 

Regards,

Pat

 





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

Announcements
secondImage

Congratulations!

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!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

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