Forum Discussion
Solved
Dynamic filtering/slicing if text contains
I have the following data: Date Text
2018-11-01 This is some random text
2018-04-03 Some test mumbling here
2018-02-01 Whatever we write here I have a visual (line chart) displayin...
Hi DennisGaida
May be you could use a MEASURE like
Measure = VAR searchvalue = SEARCH ( SELECTEDVALUE ( Text_Queries[Column1] ), SELECTEDVALUE ( Table1[Text] ), , BLANK () ) RETURN IF ( searchvalue > 0, "Found" )See the attached file. I am not sure if this what you need
Hi Zubair_Muhammad,
The Measure for the list works great, but whenever I select more than one item from Column1, the filter appears to cancel out and show all results as if no filter was applied. Selecting 1 filter row from Column1 works as expected. How can we enable multi-select?
Zubair_Muhammad
Community Champion
Community Champion
Good Question
In that case we can adjust the MEASURE as follows
Measure =
VAR mycount =
COUNTROWS (
FILTER (
VALUES ( Text_Queries[Column1] ),
SEARCH ( [Column1], SELECTEDVALUE ( Table1[Text] ),, BLANK () )
)
)
RETURN
IF ( mycount > 0, "found" )