Reply
Frequent Visitor
Posts: 3
Registered: ‎05-13-2018
Accepted Solution

removing filter on columns for scatter plot

Hi all,

 

I am trying to visualise client potential (0€ to xxx million €) (x Axis) vs penetration (0-100%) (y Axis) for a number of clients using a scatter plot. Per default this is shown for all clients. (potential, penetration and client name is all in the same table)

think of it as follows

client potential penetration sector

A      2000        0,5           business services

B       1000        0,2           business services

C      5000         0,1           healthcare

 

The user then has the possibility of selecting a single client from a slicer. The result being that only that particular client is shown on the scatter plot.

 

However, despite the single client being selected, I would like to show also some peers (think of it as clients in the same sector). Basically if A is selected, I would also like to show B, but not C in the scatter plot. I would need to un-do the filter on the client somehow

 

I have not found anything online and have tried multiple approaches in the last hours with measures or calculatetable, but i can conceputally not get there.

 

Before giving up I wanted to try and resort to your wisdom..!

 

thanks for any inputs


Accepted Solutions
Highlighted
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: removing filter on columns for scatter plot

Hi @eliapl

In this scenario, besides the dataset you provided, create a new table as below

 

1.png

 

in this table, create two measures

 

selected client = SELECTEDVALUE(Table2[client])
selected sector = SELECTEDVALUE(Table2[sector])

 

in origial table, create a measure

 

flag = IF(SELECTEDVALUE(Table1[sector])=[selected sector],1,0)

 

then add a filter condition to this measure. 

 

2.png 

 

finally, we could get this

3.png

 

Here is my pbix.

 

Best Regards

Maggie

View solution in original post


All Replies
Highlighted
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: removing filter on columns for scatter plot

Hi @eliapl

In this scenario, besides the dataset you provided, create a new table as below

 

1.png

 

in this table, create two measures

 

selected client = SELECTEDVALUE(Table2[client])
selected sector = SELECTEDVALUE(Table2[sector])

 

in origial table, create a measure

 

flag = IF(SELECTEDVALUE(Table1[sector])=[selected sector],1,0)

 

then add a filter condition to this measure. 

 

2.png 

 

finally, we could get this

3.png

 

Here is my pbix.

 

Best Regards

Maggie