Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Use a measure in a visual advanced filter "contains" to filter when a variable contains the measure


I have a visual showing curves [hour-value] of multiple flows between two places, meaning I have as many curves as flows. Each flow has a name "origin-destination", each origin and destination being a place.

We can say that m table flow have the attributes flow[origin-destination], flow[value] and flow[hour].

Then I created a segment to filter on a place. The segment allows the user to select any place[name]. I get the selected value (the selected place) in a measure using the formula : selected_place = SELECTEDVALUE(place[name])

Now I want to filter my visual to only displays the curves for which flow[origin-destination] contains selected_destination. I tried to use the visual advanced filter "text contains" and fill it with [selected_destination] but it doesn't work.

Any workaround?

Thanks by advance!

Super User
Super User

@etiennes69 , check if text filter can help

Text Filter Slicer and how to search on Multiple columns:

Hi, text filter allows me to filter on the text but now I would need to automatically fill the text filter with the selected place in the segment (= automatically fill the text filter with a measure). Doable?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors