Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter

Hello all!

I wanted to ask whether it is possible to set the filter in the dropdown so that not only "Zimmerei" but also "Zimmerei;...." is displayed, as shown in the first screenshot. Unfortunately, only "Zimmerei" is displayed, which is actually correct, but I would still like to have an extended filter option.

The first screenshot shows all data.

 

Thanks in advance.

 

best regards

Sebastian

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , In case you want a like filter then explore Text filter

    Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

     

    If you want to additional value, the slicer needs to be on an independent/disconnected table and then you need to add cluse for additional value

     

    example

    Countrows(filter(Table1, Table1[Column1] IN VALUES('list'[Values]) || Table1[Column1] = "Zimmerei"))

     

    Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. Create measure.

    Flag = 
var _select=SELECTEDVALUE('Slicer_Table'[Slicer])
return
IF(
    CONTAINSSTRING(
        MAX('Table'[Gewerk]),_select)=TRUE(),1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , In case you want a like filter then explore Text filter

    Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

     

    If you want to additional value, the slicer needs to be on an independent/disconnected table and then you need to add cluse for additional value

     

    example

    Countrows(filter(Table1, Table1[Column1] IN VALUES('list'[Values]) || Table1[Column1] = "Zimmerei"))

     

    Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. Create measure.

    Flag = 
var _select=SELECTEDVALUE('Slicer_Table'[Slicer])
return
IF(
    CONTAINSSTRING(
        MAX('Table'[Gewerk]),_select)=TRUE(),1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Anonymous!

       

      Thank you so much!

       

      Best Regards,

      Sebastian