Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
79 | |
53 | |
39 | |
36 |
User | Count |
---|---|
100 | |
85 | |
47 | |
46 | |
44 |