Forum Discussion

ZR2023's avatar
ZR2023
Frequent Visitor
3 years ago
Solved

Edit Interactions Does Nothing

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!

Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    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

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    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