Power BI – 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 Shared,  Product Category  in Column Series, Sales in Column values, Profit in Line values

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

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

• Now click on Table visual None Icon

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

• 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

Now click on Chart Visual and see the result:

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