Forum Discussion
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 ?
DTSpowerbi Anonymous MaxPowerBI
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
Hi mokrane_bob ,
I would add a separate table with two columns and filter in that table. Table could look like this:
Brand multiple Brand Adidas, Puma, Tommy Hilfiger Adidas Adidas, Puma, Tommy Hilfiger Puma Adidas, Puma, Tommy Hilfiger Tommy Hilfiger Adidas, Nike, Asics Adidas Adidas, Nike, Asics Nike Adidas, Nike, Asics Asics Nike, Zara, Channel Nike Nike, Zara, Channel Zara Nike, Zara, Channel Channel Hugo Boss, Puma Hugo Boss Hugo Boss, Puma Puma Thus, you could make a relationship between your column and that new table.
Regards, Max
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.
- Zubair_Muhammad
Community Champion
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 )
