cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mokrane_bob Frequent Visitor
Frequent Visitor

Filter in culumn with multiple value

Hello i'm dealing with a column which has multiple values in Power Bi.

I'm trying to find a way to how to filter ?

Exemple : when i select Adidas in filter, i will have the two first rows.

 

i have to precise that i have 15 brands, and the output in Brand Column depends on the choice of people

I don't want to Split, and pivot the column because i will have a duplicated rows. is there any way ?

 

Capture.PNG

 

 

@DTSpowerbi @PowerBI4Life @MaxPowerBI 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Filter in culumn with multiple value

@mokrane_bob 

 

You can use a MEASURE as visual filter.

Please see attached file with your sample data

 

Measure =
IF (
    CONTAINSSTRING (
        SELECTEDVALUE ( Data[Brand] ),
        SELECTEDVALUE ( FilterTable[Filter] )
    ),
    1
)

 

3 REPLIES 3
MaxPowerBI Frequent Visitor
Frequent Visitor

Re: Filter in culumn with multiple value

Hi @mokrane_bob ,

 

I would add a separate table with two columns and filter in that table. Table could look like this: 

Brand multipleBrand
Adidas, Puma, Tommy HilfigerAdidas
Adidas, Puma, Tommy HilfigerPuma
Adidas, Puma, Tommy HilfigerTommy Hilfiger
Adidas, Nike, AsicsAdidas
Adidas, Nike, AsicsNike
Adidas, Nike, AsicsAsics
Nike, Zara, ChannelNike 
Nike, Zara, ChannelZara
Nike, Zara, ChannelChannel
Hugo Boss, PumaHugo Boss
Hugo Boss, PumaPuma

Thus, you could make a relationship between your column and that new table.

 

Regards, Max

mokrane_bob Frequent Visitor
Frequent Visitor

Re: Filter in culumn with multiple value

Hi  @MaxPowerBI 

 

It would be a greate solution if i have a constent input in the Column

but my problem is that the input in the Column changes every time. i can have Thousands of rows with multiple combinaison of those Brand.

 

Highlighted
Super User
Super User

Re: Filter in culumn with multiple value

@mokrane_bob 

 

You can use a MEASURE as visual filter.

Please see attached file with your sample data

 

Measure =
IF (
    CONTAINSSTRING (
        SELECTEDVALUE ( Data[Brand] ),
        SELECTEDVALUE ( FilterTable[Filter] )
    ),
    1
)