cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eliapl Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

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

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 132 members 1,609 guests
Please welcome our newest community members: