Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi all, I created a table and scatter plot chart that looks like this
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.
May I know how to edit it to make it to the visualization i want?
Solved! Go to Solution.
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 :
Measure for markers color :
Example of dynamic measure for a table :
Applying conditional formatting:
Result :
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
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
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 :
Measure for markers color :
Example of dynamic measure for a table :
Applying conditional formatting:
Result :
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