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
eliapl
Regular 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
v-juanli-msft
Community Support
Community Support

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

1 REPLY 1
v-juanli-msft
Community Support
Community Support

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
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.