Reply
Regular Visitor
Posts: 16
Registered: ‎03-08-2017
Accepted Solution

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.

 

 


Accepted Solutions
Highlighted
Super Contributor
Posts: 1,366
Registered: ‎07-17-2016

Re: Custom cluster

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


All Replies
Super Contributor
Posts: 1,366
Registered: ‎07-17-2016

Re: Custom cluster

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

Regular Visitor
Posts: 16
Registered: ‎03-08-2017

Re: Custom cluster

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"

Highlighted
Super Contributor
Posts: 1,366
Registered: ‎07-17-2016

Re: Custom cluster

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