Edit Interactions Does Nothing

[ZR2023]

It appears my edit interaction button does nothing.

I want to see for example:

All expense types by category (as shown)

Total sales, cost of sales, and profit by year (as shown)

AND I want to see total revenue and expense by PROJECT only (showing all projects in screenshot)

So when I filter for 1 project, it also filters the other two tables, even though it seems that my edit interaction is off.

I just want the bottom table to be filtered for 1 project but the top 2 tables to show P&L for all projects.

Please help!

[mussaenda · Accepted solution]

Hi @ZR2023 ,

Create a slicer and turn off the interaction of slicer to the table that you dont want to affect. 

Filter Pane is not a visual so it will not be affected by the edit interaction function in Power BI

[Idrissshatila]

Hello @ZR2023 ,

So the thing is you want to edit interaction with the visual that you will click the filter from and not from the filter pane.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡