Filter

[Sebastian0406]

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

[amitchandak · Accepted solution]

@Sebastian0406 , 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

[v-yangliu-msft · Accepted solution]

Hi  @Sebastian0406 ,

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

[Sebastian0406]

Hi, @v-yangliu-msft!

Thank you so much!

Best Regards,

Sebastian

[amitchandak · Accepted solution]

@Sebastian0406 , 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

[Sebastian0406]

Thank you @amitchandak !