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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
profilewatercli
Regular Visitor

Scatter plot chart interaction dont zoom in

Hi all, I created a table and scatter plot chart that looks like this

profilewatercli_0-1740706696801.png

the plan to is to make sure that when i click on one of the line item below, the scatter plot will grey out all the other data point and highlight the datapoint selected. But what i get now is that it will zoom in like the scatter plot chart below, which i dont want.

profilewatercli_1-1740707144403.png

May I know how to edit it to make it to the visualization i want?

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @profilewatercli

Unfortunately, Power BI does not support "Highlight" interaction for Scatter Plot charts. The only interaction available is filtering, which causes the zoom effect you're seeing.

To achieve the effect you want, you can use a disconnected table for category selection and apply conditional formatting to change the marker colors dynamically. This requires using measures instead of direct table relationships. Here’s how you can do it:

Create a separate category table (not linked to the main data).
Use a measure to detect the selected category.
Apply conditional formatting on the scatter plot markers to highlight only the selected category and grey out the others.
Example :

Ritaf1983_0-1740808681612.png

Measure for markers color :

marker color =
if(SELECTEDVALUE('filtering'[market_area])=SELECTEDVALUE('Table'[market_area]),"Blue","Grey")

Example of dynamic measure for a table :

Ritaf1983_1-1740808771533.png

Applying conditional formatting:

Ritaf1983_2-1740808832080.pngRitaf1983_3-1740808849749.png


Result :

Ritaf1983_4-1740808885516.png

The pbix is attached

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



 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @profilewatercli ,

 

Thanks for your posing. I think Ritaf1983 already has a great reply and a detailed explanation. Could you please tell us if you have solved your problem?

If so, please accept her reply as solution. More people will benefit from it.

 

Best Regards,

Stephen Tao

Ritaf1983
Super User
Super User

Hi @profilewatercli

Unfortunately, Power BI does not support "Highlight" interaction for Scatter Plot charts. The only interaction available is filtering, which causes the zoom effect you're seeing.

To achieve the effect you want, you can use a disconnected table for category selection and apply conditional formatting to change the marker colors dynamically. This requires using measures instead of direct table relationships. Here’s how you can do it:

Create a separate category table (not linked to the main data).
Use a measure to detect the selected category.
Apply conditional formatting on the scatter plot markers to highlight only the selected category and grey out the others.
Example :

Ritaf1983_0-1740808681612.png

Measure for markers color :

marker color =
if(SELECTEDVALUE('filtering'[market_area])=SELECTEDVALUE('Table'[market_area]),"Blue","Grey")

Example of dynamic measure for a table :

Ritaf1983_1-1740808771533.png

Applying conditional formatting:

Ritaf1983_2-1740808832080.pngRitaf1983_3-1740808849749.png


Result :

Ritaf1983_4-1740808885516.png

The pbix is attached

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



 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors