Forum Discussion

maybevlad's avatar
maybevlad
Helper I
9 years ago
Solved

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 ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi maybevlad,

     

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

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

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

 

Regards

  • maybevlad's avatar
    maybevlad
    Helper I
    9 years ago

    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"

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi maybevlad,

       

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

       

      Regards