Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
armandogomez
New Member

What about the "Cluster Values" Option in Power Bi

Hi all

 

I'm wondering if the "Cluster Values" option in Power Query is still working or if it was deprecated for any reason.

I need to apply this powerful function to a column that contains values that do not all time has the exact value but similar values that I need to solve.


Example:
I have some rows with values like "James", but there are some other rows in the same columns with values like "Jum" or "Jame" and for me, they are the same and need to be treated all these values as James.

armandogomez_0-1697993876874.png

 

If there are any comments, I would appreciate it.

Any idea on how to have the same outcome as this option did to deal with fuzzy values in a column?

 

Thank you

Armando

1 REPLY 1
BA_Pete
Super User
Super User

Hi Armando,

 

The Cluster Values column is only available in Power Query online (Dataflows).

BA_Pete_0-1698074030424.png

 

Try adding your M code to a Dataflow and using the function there.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors