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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!

3 REPLIES 3
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.