Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 it to show only rows with defined strings, e.g. "idoso", "furto", "com risco".
Thank you all in advance!
Solved! Go to Solution.
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 )
)
)
Proud to be a Super User!
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 )
)
)
Proud to be a Super User!
Ok, I saw it: I forgot to put the columns in the visual 🤣.
Thank you very much, that's what I needed!
You can the measure to the visual filter tile and filter it from there so it doesn't show in your table . [Measure] is not empty/blank
Proud to be a Super User!
Done and it worked! Thank you again!
Hi! I tried that and the visual gave me no result. There's how I did it:
Did I do anything wrong? Did I miss anything?
@WilliamAzevedo , Are looking for a search kind of option
Try Text Filter
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE
Thank you for your answer! It doesn't fit my needs, since the search is limited to a single term, but it got me to think: is it possible to do that filtering using a measure, or through a new column using DAX?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |