Forum Discussion

profilewatercli's avatar
profilewatercli
Regular Visitor
1 year ago
Solved

Scatter plot chart interaction dont zoom in

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 ...
  • Ritaf1983's avatar
    1 year ago

    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 :

    Measure for markers color :

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

    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