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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
maybevlad
Helper I
Helper I

Custom cluster

I have one colum with some values like

scot/english

english/scot

english

scot

so i want to filter my data by putting all this values in one cluster "english"

if it some easy way to do this?) i can make some more column and fill it with custom values like if ... then...

but mb its more easy way?

replace data not good variant, couse i want to update info every month.

 

 

1 ACCEPTED SOLUTION

Hi @maybevlad,

 

In this scenario, could you go to check if the custom visual Attribute Slicer on Power BI Visual Gallery helps?Smiley Happy

 

Regards

View solution in original post

3 REPLIES 3
v-ljerr-msft
Employee
Employee

Hi @maybevlad,

 

Have you tried using SEARCH function in this scenario? The formula below to create a new calculate column for cluster is for your reference.Smiley Happy

New Cluster =
IF (
    SEARCH ( "english", Table1[Column1], 1, 0 )
        + SEARCH ( "scot", Table1[Column1], 1, 0 )
        > 0,
    "English",
    "Others"
)

r1.PNG

 

Regards

Not so good) Couse i want to filter all info via 20+ claster and want to use for this "filter" vvisualisation, as i understand its impossible to do this using "search"

Hi @maybevlad,

 

In this scenario, could you go to check if the custom visual Attribute Slicer on Power BI Visual Gallery helps?Smiley Happy

 

Regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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