Home » Power BI » Power BI – Edit Interactions

Power BI – Edit Interactions

Edit Interactions

Power BI provides you to very cool features of visual Interaction, by default this feature is enable, that’s means when you select any slicer value or click any visual by default all visuals get filtered on the basis of click or select value.

You can off the Interaction of visuals to each other, Let’s start with an example:

Step 1: Download Sample data : SuperStoreUS-2015.xlxs




Step 2: Drag three visuals in Page as mentioned below

  • Slicer:  Drag Product Category in Field
  • Table: Drag Product Category, Region, Sales, Profit in Values
  • Line & Clustered Column Chart: Drag Region in SharedProduct Category  in Column Series, Sales in Column values, Profit in Line values
Power Bi Visuals

Power Bi Visuals



Step 3: Now select Furniture from Slicer, See below image output, both visuals are filter according to selected slicer values, because by default visual Interactions is Enable.

Visuals in Power Bi

Visuals in Power Bi



Step 4: How to OFF Visual Interactions?

Now we will off Table Interactions for Slicers & Chart, that’s mean Table visual will not change on slicer or other visual click.

  • Select Slicer & Go to the Format tab
  • Click on Edit Interactions
Edit Interactions

Edit Interactions



  • Now click on Table visual None Icon
Edit Interaction off for Table

Edit Interaction off for Table

  • Click on Edit Interaction button under Format tab to close & save this change
  • After that select Chart & Go to Format Tab and click on Edit Interaction button
  • Click on Table visual None Icon
Edit Interaction off for Chart

Edit Interaction off for Chart

  • Click on Edit Interaction button under Format tab to close & save this change

Now your Interaction for Table has been off, now put filter on Slicer and see the result,

Output-1

Output-1



Now click on Chart Visual and see the result:

Output 2

Output 2

As you see, Table is not filtering on click of chart & Slicer values due to Edit Interactions off.

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.




Recommended Power Bi Post:

Power Bi Performance Analyzer

How to create Custom Theme in Power Bi

Custom Tooltips in Power Bi

Enable Syncs Slicers in Power Bi

Power Bi Interviews Q & A

1 thought on “Power BI – Edit Interactions”

  1. Edit interactions are turned off for a slicer S1 between other slicers s2, s3 and other visuals on a page. But i make selection on slicer S1, why does all the visuals and slicers spin/refresh causing queries in performance analyzer?. Any thoughts please advise
    Thanks

Leave a Reply