Forum Discussion

Advocate II

3 years ago

Solved

Filter Table visual based on strings

Hello, everyone. Is it possible to filter rows in a Table visual (or similar) based on text strings, preferably multiple strings? I have the following visual: And I would like this visual ...

Need Help

danextian
3 years ago
Hi WilliamAzevedo ,

If your search criteria is constant, you may try the following DAX measure. Anything that is not blank matches any of the text string. Just change the text strings accordingly. Also attached is a sample pbix for your reference.

Filter = VAR CriteriaTable = DATATABLE ( "Criteria", STRING, { { "poca" }, { "santana" }, { "com risco" } } ) RETURN COUNTROWS ( FILTER ( CriteriaTable, SEARCH ( [Criteria], SELECTEDVALUE ( Data[Column2] ), 1, 0 ) ) )
Filter Table visual based on strings.pbix25 KB

danextian

Super User

3 years ago

Hi WilliamAzevedo ,

If your search criteria is constant, you may try the following DAX measure. Anything that is not blank matches any of the text string. Just change the text strings accordingly. Also attached is a sample pbix for your reference.

Filter = 
VAR CriteriaTable =
    DATATABLE ( "Criteria", STRING, { { "poca" }, { "santana" }, { "com risco" } } )
RETURN
    COUNTROWS (
        FILTER (
            CriteriaTable,
            SEARCH ( [Criteria], SELECTEDVALUE ( Data[Column2] ), 1, 0 )
        )
    )

Filter Table visual based on strings.pbix25 KB