Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
etiennes69
Frequent Visitor

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

Hello,

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!

4 REPLIES 4
Drake1002
Frequent Visitor

Did you get the solution?

 

amitchandak
Super User
Super User

@etiennes69 , check if text filter can help

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

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?

Did you ever find a solution to this?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors