Forum Discussion
Solved
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 ha...
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 )
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.
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
)