Conditional Filtering in Scatter Plot

[adrmar]

Hello everyone,

I am currently struggling with my scatter plot in Power BI. 

Basically I want to map all the topics my department is currently working on. So in the middle of the chart I have my head of department and surrounding it I have all the relevant topics. I did this manually by assigning coordinates for each topic. This worked very well and I have a nice bubble map. What I now want is to filter the topics according to responsibilities. The problem is that for a certain topic there is usually more than one person responsible. 
What I want is a filter where I can click on James and get all the topics where James is responsible/included. But what I get for now in my filter is every combination of responsibilities e.g. "James"; "James, Carl" (as listed in my Excel under Responsibilities (Names)). Alternatively I created the column Responsibility (Numbers) where my idea was to then create an IF Clause so that if a topic contains the value 1 it is assigned to James. And that this way I can create a filter where only the individual names appear. 

I would be very thankful for any help!

(disclaimer: I have about 50 topics but only included a few which is why according to the coordinates the head of unit would not be in the middle)

[Anonymous · Accepted solution]

Hi @adrmar ,

You could create a measure for this.

And also you need to make sure there's no relationship between tables.

Measure  = 
var _select=SELECTEDVALUE('Table (2)'[Name])
return
IF(
    CONTAINSSTRING(MAX('Table'[Responsibilities(Names)]),_select)=TRUE(),1,0)

Then put the measure into the visual-level filter, set up show items when the value is 1. In the example, I used a table visual as an example.

Result:

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.