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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
v-stephen-msft
Community Support
Community Support

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.