Forum Discussion

Guru_BI's avatar
Guru_BI
Frequent Visitor
10 months ago
Solved

How to stop filtering from one visualization to other visualization in Power BI Desktop

Hi,

I have a scenario with two scatter plot visualizations. Consider country, region as filters and Measure 1 in first scatter plot, same country and region as filters and measure 2 in second scatter plot. If I select (mouse click) one measure value on the first visualization, by default it filters in second visualization and display the values for selected country, region and its related Measure 2 values. My requirement is even If I selected values in first visualization it should not filter in second visualization. Below are the options I tried,

Edit interactions - when selecting the first visaulaization, it doesn't show the disable option for second visualization and other visualizations. It shows enable options for other slicers, shapes and text boxes.

Keep all filter - Doesn't work

Responsive - Disable, doesn't work.

 

Appreciate your help on this ! ! !  

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • rohit1991's avatar
    rohit1991
    Icon for Super User rankSuper User
    10 months ago

    Hii Guru_BI 

     

    Power BI cannot stop visual-to-visual filtering for scatter charts.
    Scatter plots do not support “Edit Interactions >> None”, which is why you are not seeing the disable option. For this visual type, cross-highlighting is always enabled and cannot be turned off.
    So if you click a point in Scatter Chart 1, Scatter Chart 2 will always get filtered this behaviour cannot be disabled in Desktop.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    10 months ago

    use different measures. Use explicit REMOVEFILTERS in those measures to limit the interactions.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    10 months ago

    Hi Guru_BI 

     

    I can't replicate this issue. Edit interactions should be aboe to change the interaction settings between visuals. You might want to move the other visual so the interaction setting appears and not obscured by settings from the other visuals

     

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Guru_BI,

    Thank you rohit1991,lbendlin for your insights.

    Power BI behaves this way because, by default, visuals cross-filter each other. Selecting a point in Scatter Plot 1 will automatically filter Scatter Plot 2. To stop this, go to Edit interactions and set the interaction from Scatter Plot 1 to Scatter Plot 2 to None.

    How visuals cross-filter each other in a Power BI report - Power BI | Microsoft Learn

    Change how visuals interact in a report - Power BI | Microsoft Learn

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Guru_BI,

    Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Guru_BI,

    Checking in to see if your issue has been resolved. let us know if you still need any assistance.

     

    Thank you.